Ispirer Migration Knowledge Base

User Tools

Site Tools

You are here: Ispirer Migration Knowledge Base » Ispirer Migration Knowledge Base » User's Guide » Check List » Setting up Source User Privileges

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
sqlways:users-guide:check-list:setting-up-source-user-privileges [May 17, 2018, 09:52:47 AM] – [Microsoft SQL Server] alexandr.kirpichnysqlways:users-guide:check-list:setting-up-source-user-privileges [May 31, 2023, 05:28:12 PM] (current) – external edit 127.0.0.1
Line 1: Line 1:
 \\ \\
-[[http://www.ispirer.com|Ispirer Home Page]] +[[https://www.ispirer.com|Ispirer Website]] 
-[[http://www.ispirer.com|Ispirer SQLWays Migration Product Page]] +[[https://www.ispirer.com/products/migration-toolkit|Ispirer Toolkit Overview]] 
-[[http://www.ispirer.com/?click=RequestSQLWays&from=IspirerWIKI|Request SQLWays]]+[[https://www.ispirer.com/download/download-demo|Free Trial]]
 ====== Setting up Source User Privileges ====== ====== Setting up Source User Privileges ======
  
Line 13: Line 13:
   * GRANT SELECT ON dba_users   * GRANT SELECT ON dba_users
   * GRANT SELECT ON dba_part_key_columns   * GRANT SELECT ON dba_part_key_columns
-  * GRANT SELECT ON dba_sysnonyms+  * GRANT SELECT ON dba_synonyms
   * GRANT ALL [PRIVILEGES] ON OWNER.OBJECT_NAME for each object that needs to be migrated   * GRANT ALL [PRIVILEGES] ON OWNER.OBJECT_NAME for each object that needs to be migrated
      
Line 32: Line 32:
  
 You can just initiate **GRANT DBA TO user_name**. You can just initiate **GRANT DBA TO user_name**.
 +
 +
 +The minimum privileges required to collect information about the DDL of objects are the following:
 +  * GRANT CREATE SESSION TO YOUR_ORACLE_USER;
 +  * GRANT SELECT ANY DICTIONARY TO YOUR_ORACLE_USER;
 +
 +Please note that in this case it is necessary to select "DBA" option on the Source Options page. To select "DBA" option click on the "Advanced..." button as shown in the screenshot below:
 +
 +{{:sqlways:users-guide:check-list:dba_ora.png|}}
  
  
Line 70: Line 79:
 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 86:
 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 a 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'@'%';
  
Line 96: Line 105:
 When we use Teradata as a source database in the SQLWays Wizard tool, we need to specify the user that will be able to read information from the system tables. You can utilize a user that already exists in your source database or create a new one and assign appropriate privileges to him. So to create a new user you can apply the statement below: When we use Teradata as a source database in the SQLWays Wizard tool, we need to specify the user that will be able to read information from the system tables. You can utilize a user that already exists in your source database or create a new one and assign appropriate privileges to him. So to create a new user you can apply the statement below:
  
-   *  CREATE USER test_user as PASSWORD = Ispirer_1999 PERM = 100000000;+   *  CREATE USER test_user as PASSWORD = Pwd PERM = 100000000;
  
-The user that you will utilize should have select privilege on the DBC.TVM,  DBC.Dbase, DBC.triggersTbl. So to assign the select privilege you need to execute the following statements:+The user that you will utilize should have the select privilege on the DBC.TVM,  DBC.Dbase, DBC.triggersTbl. So to assign the select privilege you need to execute the following statements:
  
    * grant select on DBC.TVM to test_user ;    * grant select on DBC.TVM to test_user ;
Line 134: Line 143:
  
 The user that you will use should have select privilege on the SYS.sysuserperm, SYS.sysprocedure, SYS.sysviews, SYS.systable, SYS.sysprocparm, sysdomain, SYS.systrigger, sysgroup, sysusers, sysusertype, sys.syscolumn, sys.sysindex, sys.sysixcol, sys.sysfkcol, sys.sysforeignkey, sys.sysconstraint, sys.sysevent, sys.syseventtype, sys.sysschedule tables.  The user that you will use should have select privilege on the SYS.sysuserperm, SYS.sysprocedure, SYS.sysviews, SYS.systable, SYS.sysprocparm, sysdomain, SYS.systrigger, sysgroup, sysusers, sysusertype, sys.syscolumn, sys.sysindex, sys.sysixcol, sys.sysfkcol, sys.sysforeignkey, sys.sysconstraint, sys.sysevent, sys.syseventtype, sys.sysschedule tables. 
-So to assign the select privilege you need to execute GRANT statement for all these system tables. Here is example of a grant statement:+So to assign the select privilege you need to execute GRANT statement for all these system tables. Here is an example of a grant statement:
  
    * grant select on SYS.sysuserperm to test_user ;    * grant select on SYS.sysuserperm to test_user ;
Line 141: Line 150:
  
 You can just initiate **GRANT DBA TO test_user**. You can just initiate **GRANT DBA TO test_user**.
- 
- 
-\\ 
-[[http://www.ispirer.com|Ispirer Home Page]] 
-[[http://www.ispirer.com|Ispirer SQLWays Migration Product Page]] 
-[[http://www.ispirer.com/?click=RequestSQLWays&from=IspirerWIKI|Request SQLWays]] 
© 1999-2024, Ispirer Systems, LLC. All Rights Reserved.