How to query user permissions in Oracle

Source: Internet
Author: User

The types of        data dictionary views are:user,all  and  DBA, respectively. User_*: Information about the object that the user owns, that is, the object information that the user has created all_*: information about the objects that the user can access, information about the objects that the user creates themselves, and the information that is created by the other user dba_*: Information about the objects in the entire database ( Here the * can be tables,indexes,objects,users and so on.  ) 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 characters select * from dba_roles;  5. View the roles owned by the user select * from dba_role_privs;  select * from user_role_privs;  6. View the default tablespace for the current user select username,default_tablespace from user_users; 7. View specific permissions for a role such as Grant connect,resource,create session,create view to tesT 8, view RESOURCE with those permissions with select * from dba_sys_privs where  grantee= ' RESOURCE '


How to query user permissions in Oracle

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.