Thursday, February 20, 2020

How to list the privileges inside the Role in oracle database?

Here is the 2 views used to list the privileges inside the roles:

ROLE_TAB_PRIVS==> used to list table level privilege
ROLE_SYS_PRIVS ==> used to list system level privilge


SQL> select PRIVILEGE from role_sys_privs where ROLE='RESOURCE';

PRIVILEGE
----------------------------------------
CREATE CLUSTER
CREATE SEQUENCE
CREATE TRIGGER
CREATE TABLE
CREATE PROCEDURE
CREATE TYPE
CREATE OPERATOR
CREATE INDEXTYPE


8 rows selected.

select TABLE_NAME,PRIVILEGE from role_tab_privs where ROLE='TEST';

3 comments:

  1. The article is so appealing. You should read this article before choosing the Big data engineering automation you want to learn.

    ReplyDelete
  2. Unlike other analytics services,Azure Synapse Analytics allows you to create custom applications to run your own custom logic, and export the results using a variety of different data formats. This means that you can create your own application using any language you want, and then run it on any platform you want, and you can use it for a wide variety of different purposes.

    ReplyDelete