Query on Creation

[ashlee]

I know that we can create synonyms as public as well as private as the need of the user. Is it possible to create sequence also as public or private just like synonyms? Someone provide a detailed idea on this process.

[rachelle]

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’;