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!

grant select sequence to other users

485737Jun 8 2006 — edited Jun 8 2006

Hi all,

Assume: I have a user "A" who have table name "test" and sequence name "test_seq". How can the user "B" able to select on the sequence "test_seq" of user A, by this command below:

connect B/password
SELECT test_seq.nextval from dual;

Thanks,

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 6 2006

Added on Jun 8 2006

#general-database-discussions

2 comments

643 views