Ispirer Website
Ispirer Capabilities - Oracle Migration
Free Trial
MySQL Users to Oracle
Ispirer SQLWays Wizard tool is able to extract MySQL users and convert them to Oracle. Default password “SQLWays” is used for migrated users in Oracle. Database administrator should change password for migrated users manually. As DEFAULT USERS TABLESPACE and QUOTA EQUAL 100M are used. These two parameters can be modified in the sqlways_wzd.ini file.
MySQL:
create user 'user1'@'%' identified by 'SQLWays';
Oracle:
CREATE USER user1 IDENTIFIED BY SQLWays DEFAULT TABLESPACE USERS QUOTA 100M ON USERS;
Also Ispirer SQLWays Wizard is able to extract privileges for MySQL users and convert them to Oracle. Table privileges mapping is provided below:
| MySQL | Oracle |
|---|---|
| Database level privileges | |
| grant select on *.* to 'user1'@'%'; | grant SELECT ANY TABLE to user1; |
| grant insert on *.* to 'user1'@'%'; | grant INSERT ANY TABLE to user1; |
| grant update on *.* to 'user1'@'%'; | grant UPDATE ANY TABLE to user1; |
| grant delete on *.* to 'user1'@'%'; | grant DELETE ANY TABLE to user1; |
| grant create on *.* to 'user1'@'%'; | grant CREATE ANY TABLE to user1; |
| grant drop on *.* to 'user1'@'%'; | grant DROP ANY TABLE to user1; grant DROP ANY VIEW to user1; |
| grant index on *.* to 'user1'@'%'; | grant CREATE ANY INDEX to user1; grant ALTER ANY INDEX to user1; grant DROP ANY INDEX to user1; |
| grant grant option on *.* to 'user1'@'%'; | grant GRANT ANY OBJECT PRIVILEGE to user1; grant GRANT ANY PRIVILEGE to user1; |
| grant alter on *.* to 'user1'@'%'; | grant ALTER ANY TABLE to user1; |
| grant execute on *.* to 'user1'@'%'; | grant EXECUTE ANY PROCEDURE to user1; |
| grant create routine on *.* to 'user1'@'%'; | grant CREATE ANY PROCEDURE to user1; |
| grant alter routine on *.* to 'user1'@'%'; | grant ALTER ANY PROCEDURE to user1; grant DROP ANY PROCEDURE to user1; |
| grant trigger on *.* to 'user1'@'%'; | grant CREATE ANY TRIGGER to user1; grant ALTER ANY TRIGGER to user1; grant DROP ANY TRIGGER to user1; |
| grant create view on *.* to 'user1'@'%'; | grant CREATE ANY VIEW to user1; |
| grant create user on *.* to 'user1'@'%'; | grant CREATE USER to user1; grant ALTER USER to user1; grant DROP USER to user1; |
| grant create tablespace on *.* to 'user1'@'%'; | grant CREATE TABLESPACE to user1; grant ALTER TABLESPACE to user1; grant DROP TABLESPACE to user1; |
| Object level privileges | |
| grant alter on testdb.tab to 'user1'@'%'; | grant ALTER ON testdb.tab to user1; |
| grant select on testdb.tab to 'user1'@'%'; | grant SELECT ON testdb.tab to user1; |
| grant insert on testdb.tab to 'user1'@'%'; | grant INSERT ON testdb.tab to user1; |
| grant update on testdb.tab to 'user1'@'%'; | grant UPDATE ON testdb.tab to user1; |
| grant delete on testdb.tab to 'user1'@'%'; | grant DELETE ON testdb.tab to user1; |
| grant create on testdb.tab to 'user1'@'%'; | grant CREATE ON testdb.tab to user1; |
| grant index on testdb.tab to 'user1'@'%'; | grant INDEX ON testdb.tab to user1; |
| grant execute on procedure testdb.sp_test to 'user1'@'%'; | grant EXECUTE ON testdb.sp_test to user1; |