Skip to Main Content

Oracle Database Discussions

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!

Do I need to grant create sequence?

cartesianJul 10 2009 — edited Jul 10 2009
I'm a DBA and have created a new apps user for developers to work with. I have granted connect, resource, create session, create table and create synonym to that user.

Before it goes to live I ran a few checks to see what objects the new user had created in development. It had created tables and synonyms which is what I would have expected but it had also created sequence objects. I checked the privileges to see if the developers had added "create sequence" without me knowing but they hadn't.

Does one of the other privileges I've granted allow the user to create sequences or do I need to grant it implicitly when it goes into Live?

Thanks
This post has been answered by 539769 on Jul 10 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 7 2009
Added on Jul 10 2009
6 comments
19,655 views