Ispirer Ispirer
 

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

sqlways:users-guide:check-list:setting-up-source-user-privileges [May 17, 2018, 09:52:47 AM]
alexandr.kirpichny [Microsoft SQL Server]
sqlways:users-guide:check-list:setting-up-source-user-privileges [May 30, 2018, 01:41:50 PM] (current)
alexandr.kirpichny [DB2 LUW]
Line 70: Line 70:
 Or you can grant access to all the data (ie, all tables in all schemas), then you need to grant dataaccess privilege to the user: Or you can grant access to all the data (ie, all tables in all schemas), then you need to grant dataaccess privilege to the user:
  
-   * db2 grant dataaccess on database to the user user1;+   * db2 grant dataaccess on database to user user1;
  
  
Line 77: Line 77:
 To be able to connect to a database and to extract DDL of objects in MySQL, you need to create a user and assign select privileges to this user. As a template you can use the queries below: To be able to connect to a database and to extract DDL of objects in MySQL, you need to create a user and assign select privileges to this user. As a template you can use the queries below:
  
-   * create user 'test_perm'@'%' identified by 'root';+   * create user 'test_perm'@'%' identified by 'root';
    * grant select on *.* to 'test_perm'@'%';    * grant select on *.* to 'test_perm'@'%';
  
sqlways/users-guide/check-list/setting-up-source-user-privileges.1526550767.txt.gz · Last modified: May 17, 2018, 09:52:47 AM by alexandr.kirpichny
 
© 1999-2018, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement