Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

dbms_streams_auth.grant_admin_privilege sys as sysdba privilege ?

591895Aug 7 2007 — edited Oct 11 2008
When I execute dbms_streams_auth.grant_admin_privilege procedure as a user granted the DBA role. I get the following error:

ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_STREAMS_AUTH", line 1211
ORA-06512: at line 2

I can only execute this command with the sys as sysdba on the oracle host. Not as system user from an external machine.

anyone know which privilege that sys user has that system doesnt ? I have tried all the execute privileges, but its not working.

Svein
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 8 2008
Added on Aug 7 2007
#performance-availability, #streams
5 comments
3,358 views