CODEWITHSUNDEEP
oracle-databasesequence
Jack
Jack

Reputation: 805

Sequence Permission in Oracle

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

Upvotes: 48

Views: 216386

Answers (2)

OPMendeavor
OPMendeavor

Reputation: 460

Just another bit. in some case i found no result on all_tab_privs! i found it indeed on dba_tab_privs. I think so that this last table is better to check for any grant available on an object (in case of impact analysis). The statement becomes:

    select * from dba_tab_privs where table_name = 'sequence_name';

Upvotes: 7

beny23
beny23

Reputation: 35018

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'

Upvotes: 90

Related Questions