GRANT Statement - Oracle to MySQL Migration

In Oracle and MySQL, the GRANT statement grants provileges or roles to a user, but some clauses differ and require conversion.

	Oracle		MySQL
1	GRANT DEBUG ON tab TO user	Access with debugger	Commented
2	GRANT CONNECT TO user	Connect to the database	GRANT USAGE ON *.* TO user
3	GRANT CREATE SESSION TO user	Connect to the database	GRANT USAGE ON *.* TO user
4	GRANT CREATE SEQUENCE TO user	Create sequences	Sequences are not supported
5	GRANT CREATE SYNONYM TO user	Create synonyms	Synonyms are not supported
6	GRANT CREATE TABLE TO user	Create tables	GRANT CREATE ON *.* TO user
7	GRANT CREATE VIEW TO user	Create tables	GRANT CREATE VIEW ON *.* TO user
8	GRANT FLASHBACK ON tab TO user	Access past states	Commented
9	GRANT INDEX ON table TO user	Create index	GRANT INDEX ON table TO user
10	GRANT ON COMMIT REFRESH ON tab TO user	Refresh view	Commented
11	GRANT QUERY REWRITE ON tab TO user	Rewrite query	Commented
12	GRANT READ ON table TO user	Read table	GRANT SELECT ON table TO user
13	GRANT RESOURCE TO user	Create objects	GRANT CREATE, CREATE VIEW, CREATE ROUTINE, TRIGGER ON *.* TO user
14	GRANT UNLIMITED TABLESPACE TO user	Unlimited amount	Commented

For more information, see Oracle to MySQL Migration.