Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Insufficient privilege
"Debadatta" <debadatta03_at_yahoo.com> a écrit dans le message de
news:ce544e9a.0504130450.3e3f6dcd_at_posting.google.com...
| 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
Your local user don't have the select privilege on sys.dba_role_privs granted to him *directly*.
Regards
Michel Cadot
Received on Wed Apr 13 2005 - 10:49:53 CDT