View Single Post

  #2 (permalink)  
Old 06-16-2007, 04:59 PM
rachelle rachelle is offline
Senior Member
 
Join Date: Apr 2006
Posts: 122
rachelle is on a distinguished road
As you have stated you can create synonyms as public as well as private as the need of the user. But it is not possible to create sequence as neither public nor private just like synonyms. But it is possible for you to give public grant to a sequence created.

For example if you have created as sequence named as example as below:
create sequence example;

You can give public grant to this example sequence as below:
grant select on example to public’;
Reply With Quote