Home » RDBMS Server » Security » create sequence privileges
create sequence privileges [message #276116] Wed, 24 October 2007 01:10 Go to next message
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

Re: create sequence privileges [message #276130 is a reply to message #276116] Wed, 24 October 2007 01:34 Go to previous message
Michel Cadot
Messages: 68313
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator


This is YOUR package, only YOU can know what is done in it and which privileges are needed.

Previous Topic: Privileges related problem
Next Topic: Role
Goto Forum:

Current Time: Thu Dec 01 08:31:01 CST 2022