• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 7151
  • Last Modified:

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.
0
gudii9
Asked:
gudii9
  • 3
  • 2
2 Solutions
 
sdstuberCommented:
grant select on schema_xyz.sequence_abc to some_user;
0
 
sdstuberCommented:
or

grant select on schema_xyz.sequence_abc to some_role;

or

grant select on schema_xyz.sequence_abc to public;
0
 
Kevin CrossChief Technology OfficerCommented:
grant select on sequence_abc to {username}

(http://p2p.wrox.com/oracle/23287-sequence-grant-oracle.html)
0
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 
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

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now