Home » RDBMS Server » Security » create sequence privileges
create sequence privileges [message #276116] Wed, 24 October 2007 01:10 Go to next message
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
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: 58616
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:

pkg_utility_db_management

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

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


Current Time: Wed Jul 30 01:19:56 CDT 2014

Total time taken to generate the page: 0.05790 seconds