| 36. 2. User Permission |
| 36. 2. 1. | To connect to the database a user must be granted the permission to create a session, which is the CREATE SESSION system privilege. | | |
| 36. 2. 2. | CREATE USER userName IDENTIFIED BY password and grant permission | | |
| 36. 2. 3. | Create user and grant permission | | |
| 36. 2. 4. | Grant all possible permissions | | |
| 36. 2. 5. | REVOKE CREATE TABLE, CREATE CLUSTER, CREATE SYNONYM, CREATE VIEW, CREATE SEQUENCE, CREATE DATABASE LINK FROM CONNECT | | |
| 36. 2. 6. | Grant CREATE SYNONYM, CREATE VIEW, CREATE DATABASE LINK, CREATE PUBLIC SYNONYM, DROP PUBLIC SYNONYM | | |
| 36. 2. 7. | Grant connect and resource permission to a user | | |
| 36. 2. 8. | Grant connect permission to a user | | |
| 36. 2. 9. | Grant with admin option | | |
| 36. 2. 10. | Grant connect to permission to all name in a table | | |
| 36. 2. 11. | grant select on tableName to userName | | |
| 36. 2. 12. | grant administer database trigger to userName | | |
| 36. 2. 13. | grant execute on dbms_rls to userName | | |
| 36. 2. 14. | grant create any context to userName | | |
| 36. 2. 15. | Revoke Permissions | | |
| 36. 2. 16. | Revoke Permissions with Cascade | | |
| 36. 2. 17. | Get user name from all_users | | |