Sequence Permission in Oracle

Question

How can I check a permission granted for particular sequence and assign permission to particular sequence from SQL*Plus. Thank you

question from:https://stackoverflow.com/questions/7166089/sequence-permission-in-oracle

Answer 1

To grant a permission:

grant select on schema_name.sequence_name to user_or_role_name;

To check which permissions have been granted

select * from all_tab_privs where TABLE_NAME = 'sequence_name'