OraFAQ Forum: Security » create sequence privileges

Home » RDBMS Server » Security » create sequence privileges

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

create sequence privileges [message #276116]

Wed, 24 October 2007 01:10

bluepower
Messages: 10
Registered: April 2007
Location: new delhi

Junior Member

hi everyone,

I am facing insufficient privileges error ORA-01031,ORA-O6512 while executing the package to create sequence:
sql>conn bhumi@orcldev

EXEC pkg_utility_db_management.sp_create_sequence('ac_fare_class_language_seq');
insufficient privileges error ORA-01031,ORA-O6512

I've already granted role named new_schema_privs containing following privileges to user bhumi:

create session.create synonym,create table,create view,create type,create procedure,create sequence,execute on dbms_crypto

role is default for the user.when i execute the select* from session_privs it shows the above mentioned privileges.....

-when i grant the create sequence privilege explicitly to user then i face no problem can anyone help me please? I am using oracle 10g on opensuse 10.2

thanks

Report message to a moderator