Home » Developer & Programmer » Forms » Views On DBA_ VIEWS
Views On DBA_ VIEWS [message #78904] Thu, 28 March 2002 11:01 Go to next message
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
Re: Views On DBA_ VIEWS [message #78907 is a reply to message #78904] Thu, 28 March 2002 17:21 Go to previous messageGo to next message
Imran
Messages: 56
Registered: November 2001
Member
Dba_Tab_privs is also a view. It is populate by x_$tables.

Imran
Re: Views On DBA_ VIEWS [message #78917 is a reply to message #78904] Sat, 30 March 2002 22:05 Go to previous message
Robert Kuhlmann
Messages: 35
Registered: March 2002
Member
Connect as sys and grant the privilege direct to the user, Then it is possibel to create a view as "user"

Robert
Previous Topic: procedure builder
Next Topic: Re: FREE TRAINING ON ORACLE AND DEVELOPER200 CONTACT BY MAIL STEP BY STEP TAINING
Goto Forum:
  


Current Time: Sun Mar 29 11:23:33 CDT 2020