Re: Insufficient privilege

Debadatta schrieb:
> 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

If you make a schema export ( OWNER=XYZ ), no of privileges on sys objects are exported ( like select on sys.dba_role_privs) , you have to extract those privileges separately...

Best regards

Maxim Received on Wed Apr 13 2005 - 14:07:25 CDT