Measure the test taker's knowledge about Oracle Objects and system permissions.

-- System permission table select * fromdba_sys_privspwherep.privilegelike

-- System permission table select * from dba_sys_privs p where p. privilege like

-- System permission list
Select * from dba_sys_privs p where p. privilege like '% LINK %'

-- Object permission table
Select * from dba_tab_privs tp where tp. owner = 'Scott'

-- What I see on the Internet:
--- ALL_COL_PRIVS indicates column authorization. The user and PUBLIC are authorized.

Select * from dba_col_privs
ALL_COL_PRIVS_MADE indicates column authorization. The user is the owner and the authorized user.

Select * from all_col_privs_made

ALL_COL_RECD indicates column authorization. The user and PUBLIC are authorized.

ALL_TAB_PRIVS indicates authorization on the object. The user is PUBLIC, the authorized or the user is the owner.

ALL_TAB_PRIVS_MADE indicates the permission on the object. The user is the owner or the principal.

ALL_TAB_PRIVS_RECD indicates the permission on the object. The user is PUBLIC or authorized.

All authorizations on the DBA_COL_PRIVS database Column

DBA_ROLE_PRIVS displays the roles granted to users or other roles

DBA_SYS_PRIVS has granted system permissions to users or roles

All permissions on DBA_TAB_PRIVS database objects

ROLE_ROLE_PRIVS: displays the roles granted to users.

Select * from role_role_privs; -- role_role_privs; indicates the role that grants this role.
-- Test the preceding -- role_role_privs is the role that grants this role.
Create role zxy_role;
Create role zxy_role_1;
Grant zxy_role_1 to zxy_role;

ROLE_SYS_PRIVS displays the system permissions granted to the user through the role
Select * from role_sys_privs; -- displays the system permissions of a role.
-- Test
Grant create table to zxy_role;

ROLE_TAB_PRIVS: displays the object permissions granted to users through roles.
Select * from ROLE_TAB_PRIVS; -- displays the object permissions of a role.
-- Test
Grant select on scott. emp to zxy_role;

SESSION_PRIVS displays all the current system permissions that a user can use
Select * from session_privs; -- displays the system permissions that users can use.

USER_COL_PRIVS: displays the column permissions. the user is the owner, Authorizer, or grantee.
Select * from user_col_privs

USER_COL_PRIVS_MADE: displays the permissions granted to the column. The user is the owner or the principal.

USER_COL_PRIVS_RECD: displays the permissions granted to the column. The user is the owner or authorized.

USER_ROLE_PRIVS: displays all roles granted to the user.
Select * from dba_role_privs; -- displays the roles that have been granted to the user.
-- Test
Grant zxy_role to scott; -- displays the role assigned to the scott user

USER_SYS_PRIVS: displays all system permissions granted to the user.

USER_TAB_PRIVS: displays all object permissions granted to the user.

USER_TAB_PRIVS_MADE: displays the object permissions granted to other users. The user is the owner.

Select * from USER_TAB_PRIVS_MADE ma where ma. grantee = 'Scott '; -- displays the system and object permissions granted to the submitter.
-- Test
Grant execute on SYS. BLASTN_MATCH to scott; -- Object permission
Grant select any table to scott; -- system permission -- tested without system permission. Only object permissions are displayed.

USER_TAB_PRIVS_RECD: displays the object permissions granted to other users. The user is the grantee'
Select * from user_TAB_PRIVS_RECD m where table_name = 't_only'; -- display
-- Test
Grant select on t_only to scott;