Shulou(Shulou.com)06/01 Report--

The types of data dictionary views are: USER,ALL and DBA. USER_*: about the object information owned by the user, that is, the object information created by the user, ALL_*: information about the objects that the user can access That is, the information of the objects created by the user plus the objects created by other users, but the information that the user has access to, DBA_*: information about the objects in the entire database (the * here can be TABLES,INDEXES,OBJECTS,USERS, etc.) 1. View all users select * from dba_user; select * from all_users; select * from user_users; 2, view user system permissions select * from dba_sys_privs; select * from all_sys_privs; select * from user_sys_privs; 3, view user object permissions select * from dba_tab_privs; select * from all_tab_privs; select * from user_tab_privs 4. View all roles select * from dba_roles; 5, view the role select * from dba_role_privs; select * from user_role_privs; 6 owned by the user, view the default tablespace select username,default_tablespace from user_users; 7 of the current user, and view the specific permissions of a role, such as grant connect,resource,create session,create view to test 8. Check what permissions RESOURCE has with SELECT * FROM DBA_SYS_PRIVS WHERE GRANTEE='RESOURCE "

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.