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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Grant sequence privilege issue

735680Sep 21 2012 — edited Sep 21 2012

Hi,

OS is windows server 2008

Database oracle 11g r2

i have created a schema with name SME having DBA privilege from SME i have created another user SME_USER using the same tablespace of SME with limited privileges. The sequence was created in SME user. I am accessing the tables from SME schema. I have given insert privilege to one of the table in SME to SME_USER,but while insertiing we are using the sequnece with name IPSRNO from SME schema. Now when i tried to insert value inot the table from SME_USER its giving me the output "Sequence does not exist". I have given the grant select privilege for sequence IPSRNO.

Please guide me on this issue.

Regards,
Bobby

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 19 2012

Added on Sep 21 2012

#general-database-discussions

10 comments

1,765 views