accessing information about permissions to all


Accessing information about permissions to all users-Object level permissions: With the use of data dictionary you can see the permissions to user. Let us get the table name from oracle. In oracle the name of the table having these permissions is user_tab_privs.

DESCRIBE USER_TAB_PRIVS ;

 SELECT * FROM USER_TAB_PRIVS;

 

Request for Solution File

Ask an Expert for Answer!!
Database Management System: accessing information about permissions to all
Reference No:- TGS0209817

Expected delivery within 24 Hours