Oracle 中的序列权限
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/7166089/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Sequence Permission in Oracle
提问by Hyman
How can I check a permission granted for particular sequence and assign permission to particular sequence from SQL*Plus. Thank you
如何检查为特定序列授予的权限并为 SQL*Plus 中的特定序列分配权限。谢谢
回答by beny23
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'
回答by OPMendeavor
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:
还有一点。在某些情况下，我在all_tab_privs上没有发现任何结果 ！我确实在dba_tab_privs上找到了它 。我认为最后一张表更适合检查对象上的任何可用授权（在影响分析的情况下）。语句变为：
select * from dba_tab_privs where table_name = 'sequence_name';
