GRANT Statement - Oracle to MariaDB Migration
In Oracle and MariaDB, the GRANT statement grants provileges or roles to a user, but some clauses differ and require conversion. 
| Oracle | MariaDB | |||
| 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 | GRANT CREATE ON *.* TO user | |
| 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 MariaDB Migration.