Insufficient privilege

From: Debadatta <debadatta03_at_yahoo.com>
Date: 13 Apr 2005 05:50:52 -0700
Message-ID: <ce544e9a.0504130450.3e3f6dcd@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 Received on Wed Apr 13 2005 - 07:50:52 CDT