Unable to grant role/privilege
Hello All, We have a db user who has been granted with the DBA role and when he is trying to grant certain perivileges to users he is getting the below error:
-----------------------------
GRANT select on dba_data_files to dsi_dpipe
*
ERROR at line 1:
ORA-01031: insufficient privileges
--------------------------
GRANT select on v_$session to dsi_dpipe
*
ERROR at line 1:
ORA-00942: table or view does not exist
------------------------
GRANT select on v_$session to dsi_dpipe
*
ERROR at line 1:
ORA-00942: table or view does not exist
Does he need to have any other Role/Privilege for doing the above operations. Any input from your end will be of great help