ocp1z0-047: Permissions--Assigning system permissions

This question is the examination authority knowledge Point, the authority divides into two kinds, the system permission and the object permission, this question mainly speaks the system authority, we first comes to understand what is the system right, what is the object permission bar.

1, System permissions: Allow users to perform specific operations in the database

A, Sysdba/sysoper These two privileges are more special

Gyj@ocm> SELECT * from Dba_sys_privs where Granteein (' SYSDBA ', ' sysoper ');  
       
No rows selected

B, DBA system permissions can be traced

Gyj@ocm> SELECT * from Dba_sys_privs where grantee= ' DBA ';  
       
Grantee                       Privilege                               ADM  
-------------------------------------------------------------------------  
DBA                            DROP any CUBE build PROCESS              Yes  
dba                           CREATE Cube                             YES  
dba                           ALTER any cube DIMENSION                Yes  
DBA                           ALTER any MINING MODEL                   Yes  
 (intermediate result omitted)  
..... .....  
............ Selected rows.

C, the normal user's system permissions

Gyj@ocm> SELECT * from  dba_sys_privs where grantee= ' Gyj ';  
       
Grantee                       Privilege                               ADM  
-------------------------------------------------------------------------  
GYJ                           Unlimited tablespace                    NO

D, System permissions on the current session

Gyj@ocm> select * from Session_privs;  
       
Privilege  
----------------------------------------  
ALTER system  
AUDIT system  
CREATE session  
ALTER  
Session Restricted session  
(intermediate result omitted) ..... ............  
.......  
Selected rows.

2, Object permissions: Allow users to access and manipulate specific objects

A, check the object permissions

Gyj@ocm> SELECT *  fromdba_tab_privs where grantee= ' Gyj ';  
       
No rows selected

B, check the rights of the object listed above

Gyj@ocm>select * from  dba_col_privs wheregrantee= ' Gyj ';  
      
O Rows Selected

Why not show the permissions of the object and the permissions listed on the object, the user Gyj obviously have the object of AH:

gyj@ocm> Show user;  
The USER is ' GYJ '  
gyj@ocm> select table_name from tabs;  
       
table_name  
------------------------------  
T10