-
Grant select on sys.dba_role_privs
Hi
Is there any way to assing GRANT SELECT ON SYS.DBA_ROLE_PRIVS to TESTUSER without not being sys user.
For example:
User ZAM has dba role with Admin options
+
I granted ZAM :
GRANT SELECT ANY TABLE TO ZAM WITH ADMIN OPTION
GRANT SELECT ANY DICTIONARY TO ZAM WITH ADMIN OPTION
GRANT GRANT ANY PRIVILEGE TO ZAM WITH ADMIN OPTION
Now if I beign ZAM execute GRANT SELECT ON SYS.DBA_ROLE_PRIVS TO TESTUSESR;
I got
ERROR at line 1:
ORA-01031: insufficient privileges
Thanks
-
I worked it out.
Login as ZAM and run GRANT SELECT_CATALOG_ROLE to TESTUSER;
Cheers
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|