Grant permissions and then check the dba_col_privs table : System Privileges « User Previliege « Oracle PL / SQL

1. Oracle PL / SQL
2. User Previliege
3. System Privileges

Grant permissions and then check the dba_col_privs table

 

grant references ( employee_id ),update( first_name,last_name,job_id,manager_id,department_id )
on hr.employees to scott;

select *
from dba_col_privs
/

 

Related examples in the same category