Mega Code Archive

 

Categories / Oracle PLSQL / User Previliege

 

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 /