Shulou(Shulou.com)05/31 Report--

This article will explain in detail how to manage the role rights of Oracle users. The content of the article is of high quality, so the editor will share it for you as a reference. I hope you will have a certain understanding of the relevant knowledge after reading this article.

1. View all users

SQL > select USERNAME from users_users

SQL > alter user scott account lock; (user lockout)

SQL > alter user scott account unlock; (unlocked by user)

2. View all roles (role: a collection of multiple permissions)

SQL > select ROLE from dba_roles

3. View the permissions that can be granted to the user

SQL > select PRIVILEGE from dba_sys_privs group by PRIVILEGE

SQL > select PRIVILEGE from dba_sys_privs where grantee = 'role name'

4. View the permissions of the current user

SQL > select PRIVILEGE from role_sys_privs

5. Query the roles owned by a user

SQL > select * from dba_role_privs where grantee = 'SCOTT'

GRANTEE GRANTED_ROLE ADMIN_ DEFAUL

--

SCOTT RESOURCE NO YES

SCOTT CONNECT NO YES

6. Authorization

SQL > grant select, update, insert on test to scott;// assign permissions to scott on the test table

SQL > grant select, update, insert on test to scott with grant option;// permissions are passed. Scott users can also grant the above permissions to other users.

SQL > grant all on test to public; / / all users can query, insert and update tables, but not delete tables

SQL > select owner, table_name from all_tables; / / tables that users can query

SQL > select table_name from user_tables; / / user-created table

Authorization for the SQL > grant dba to scott;//DBA role

7. Authority recovery

SQL > Revoke select, update, insert on test to scott;// withdraw permissions. If permissions are passed, they will also be lost.

8. Role management

SQL > create role test;// create roles

SQL > grant insert on scott.emp to test;// assigns permissions to roles

SQL > revoke insert on scott.emp to test;// revokes role permissions

SQL > grant test to jack;// grants all permissions of the role to the jack user

About how to carry on the Oracle user role privilege management to share here, hoped that the above content can have the certain help to everybody, can learn more knowledge. If you think the article is good, you can share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.