how to grant select privilege to single sequence

Hi,

I would like to grant the 'select' privilege to a sequence say sequence_abc within a schema say schema_xyz. Any links, ideas, sample code, resources highly appreciated. Thanks in advance.
LVL 7
gudii9Asked:
Who is Participating?
 
sdstuberConnect With a Mentor Commented:
or

grant select on schema_xyz.sequence_abc to some_role;

or

grant select on schema_xyz.sequence_abc to public;
0
 
sdstuberCommented:
grant select on schema_xyz.sequence_abc to some_user;
0
 
Kevin CrossConnect With a Mentor Chief Technology OfficerCommented:
grant select on sequence_abc to {username}

(http://p2p.wrox.com/oracle/23287-sequence-grant-oracle.html)
0
Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

 
Kevin CrossChief Technology OfficerCommented:
Didn't see your response, Sean, or I would not have posted. :)
0
 
gudii9Author Commented:
thank you very much
0
 
sdstuberCommented:
glad we could help.

mwvisa1  - don't worry about it.  posting within 3 minutes is "simultaneous" by my watch.  :)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.