Solved

how to grant select privilege to single sequence

Posted on 2009-05-20
6
7,116 Views
Last Modified: 2013-12-18
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
Comment
Question by:gudii9
  • 3
  • 2
6 Comments
 
LVL 73

Expert Comment

by:sdstuber
ID: 24433985
grant select on schema_xyz.sequence_abc to some_user;
0
 
LVL 73

Accepted Solution

by:
sdstuber earned 300 total points
ID: 24433990
or

grant select on schema_xyz.sequence_abc to some_role;

or

grant select on schema_xyz.sequence_abc to public;
0
 
LVL 59

Assisted Solution

by:Kevin Cross
Kevin Cross earned 200 total points
ID: 24434009
grant select on sequence_abc to {username}

(http://p2p.wrox.com/oracle/23287-sequence-grant-oracle.html)
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 59

Expert Comment

by:Kevin Cross
ID: 24434024
Didn't see your response, Sean, or I would not have posted. :)
0
 
LVL 7

Author Closing Comment

by:gudii9
ID: 31583603
thank you very much
0
 
LVL 73

Expert Comment

by:sdstuber
ID: 24460111
glad we could help.

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

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Oracle RMAN Database Restore 5 52
PLSQL procedure help with decode and null input params 5 47
Performance issue with case statement in oracle 11G 7 48
SQL Query 34 82
Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now