New answers tagged

0 votes

Is there a privilege in Oracle that lets a user view the objects in another schema?

I believe you can give a try with below views: You can query the USER_SYS_PRIVS/ DBA_SYS_PRIVS table with the following SQL query: SELECT privilege FROM USER_SYS_PRIVS WHERE GRANTEE = 'username' AND ...
Anish kumar's user avatar

Top 50 recent answers are included