Re: Insufficient privilege

Debadatta wrote:

> Hi,
>
>
> step1.
> I have taken one dump of databse lying AIX.
> step2.
> Import into local database in Windows.
> Step3.
> I found one of the view is invalid.
> Step4.
> Found out script for view.
> Step5.
> tried to run the select query separately.Query is running proper.But
> once try to run this script, it throws an error :
>
> step1.
> I have taken one dump of databse lying AIX.
> step2.
> Import into local database in Windows.
> Step3.
> I found one of the view is invalid.
> Step4.
> Found out script for view.
> Step5.
> tried to run the select query separately.Query is running proper.But
> once try to run this script, it throws an error :Insufficient
> privilige.
>
> Pl. find the script for view.
> CREATE OR REPLACE VIEW AAP_ROLE_PRIVS
> (GRANTEE, GRANTED_ROLE, ADMIN_OPTION, DEFAULT_ROLE)
> AS
> SELECT
> GRANTEE, GRANTED_ROLE, ADMIN_OPTION,
> DEFAULT_ROLE
> FROM sys.DBA_ROLE_PRIVS;
> Pl. find the script for view.
> CREATE OR REPLACE VIEW AAP_ROLE_PRIVS
> (GRANTEE, GRANTED_ROLE, ADMIN_OPTION, DEFAULT_ROLE)
> AS
> SELECT
> GRANTEE, GRANTED_ROLE, ADMIN_OPTION,
> DEFAULT_ROLE
> FROM sys.DBA_ROLE_PRIVS;
>
> waiting for u'r reply.
> Thanks

No Oracle version.
No Error message.
No help possible.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)