OraFAQ Forum: Forms » Views On DBA

Home » Developer & Programmer » Forms » Views On DBA_ VIEWS

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Views On DBA_ VIEWS [message #78904]

Thu, 28 March 2002 11:01

Tyler
Messages: 123
Registered: January 2002

Senior Member

Hello,

I am trying to implement security on a form and in doing this I have realized that I need to create a view on dba_tab_privs view. I have privs to select all from this view, but when I try to create a view on it, it's telling me that the 'table or view does not exist'...

SQL> select distinct privilege,table_name,grantee from dba_tab_privs where upper(grantee) like
2 '%0' or upper(grantee) like '%A' or upper(grantee) like '%Q';

PRIVILEGE TABLE_NAME
---------------------------------------- ------------------------------
GRANTEE
------------------------------
ALTER ACCOM_LISTING
IM_A

ALTER ACCOM_LISTING_CANTS
IM_A
...many rows selected.

SQL> create view user_privs_vu as
2 select distinct privilege,table_name,grantee from dba_tab_privs where upper(grantee) like
3 '%0' or upper(grantee) like '%A' or upper(grantee) like '%Q';

select distinct privilege,table_name,grantee from dba_tab_privs where upper(grantee) like
*
ERROR at line 2:
ORA-00942: table or view does not exist
--end

Suggestions?

T

Report message to a moderator