Oracle permission management

Introduction: Oracle DatabaseIt involves confidential data.PermissionIn order to better maintain the data security of the Oracle database.

Oracle permission management:

1. start **: lsnrctl start

2. Start oracle instance radim-startup-sid orcl (oracle Instance name)

3. log on to the oracle database: sqlplus username/password

4. log on to the database as dba (sys by default): sqlplus username/password as sysdba. The default dba account and password can be sqlplus/as sysdba.

5. create user username identified by password (the user has been created but cannot log on to the oracle database)

6. grant the user the create session permission: grant create session to username (at this time, the user can log on to the database, but cannot create a table)

7. grant the user the permission to create a table: grant create table to username (in this case, the user can create a table theoretically, but does not have the permission to use the tablespace, and all tables cannot be created successfully)

8. grant users unlimited permission to use tablespaces: grant unlimited tablespace to username

9. revoke permission: revoke permission name from username

10. query the permissions of the current user: select * from user_sys_privs

11. query the table owned by the current user: select * from user_tab_privs

12. query the permissions of columns owned by the current user: select * from user_col_privs

13. Object permission authorization: grant operation permission on username. table to anotherusername (who has the permission to authorize this object to others)

14. Credit for object permissions: revoke operation permission on username. table from anotherusername

15. grant a certain permission (regardless of the object or system permission) to all users: grant permission to public

16. The permission is accurate to the column: grant permission (columnName) on tableName to username. Note that the query and deletion cannot be accurate to the column.

This article summarizes so much for you that it may not be comprehensive. I hope you can sum up more experience in your future work.