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

This article mainly introduces "how to view Oracle user rights". In daily operation, I believe many people have doubts about how to view Oracle user rights. Xiaobian consulted all kinds of materials and sorted out simple and easy-to-use operation methods. I hope it will be helpful for you to answer the doubts about "how to view Oracle user rights"! Next, please follow the editor to study!

-- query a user's system permissions

SELECT * FROM dba_sys_privs t WHERE t.grantee = 'XXX'

-- query the permissions of a user object

SELECT * FROM dba_tab_privs t WHERE t.grantee = 'XXX'

-about permissions and roles

Connect resource permission

Grant connect,resource to user

The permissions included by the user after executing the above sql statement:

CONNECT role:-- typical rights granted to end users, the most basic

ALTER SESSION-modify session

CREATE CLUSTER-set up clustering

CREATE DATABASE LINK-establish a database link

CREATE SEQUENCE-establishing sequence

CREATE SESSION-establish a session

CREATE SYNONYM-establish synonyms

CREATE VIEW-create a view

RESOURCE role:-- granted to developers

CREATE CLUSTER-set up clustering

CREATE PROCEDURE-Establishment process

CREATE SEQUENCE-establishing sequence

CREATE TABLE-creating tables

CREATE TRIGGER-set up the trigger

CREATE TYPE-create a type

From the dba_sys_privs, you can find:

SQL > select grantee,privilege from dba_sys_privs where grantee='RESOURCE' order by privilege

GRANTEE PRIVILEGE

RESOURCE CREATE CLUSTER

RESOURCE CREATE INDEXTYPE

RESOURCE CREATE OPERATOR

RESOURCE CREATE PROCEDURE

RESOURCE CREATE SEQUENCE

RESOURCE CREATE TABLE

RESOURCE CREATE TRIGGER

RESOURCE CREATE TYPE

1. View all users:

Select * from dba_users

Select * from all_users

Select * from user_users

two。 View user or role system permissions:

Select * from dba_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 roles owned by the user or role:

Select * from dba_role_privs

Select * from user_role_privs

At this point, the study on "how to view Oracle user rights" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

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.