PL/SQL (MOSC)

MOSC Banner

dba_tab_privs : ORA-00942: table or view does not exist

edited Jun 23, 2010 3:25PM in PL/SQL (MOSC) 7 commentsAnswered
 hi,

 i have created a function to list granted users on objects, so i need to use dba_tab_privs view.

in sql worksheet it works:

select  distinct grantee from sys.dba_tab_privs;


but in function created with the same user compiler says table or view does not exist

CURSOR cur_grant IS   select  distinct grantee from sys.dba_tab_privs ;


select  distinct grantee into aaa from sys.dba_tab_privs where rownum = 1;    -> the same error


plz reply me the solution.


Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center