Re: Privileges on Sequences
- From: "Edgar Chupit" <chupit@xxxxxxxxx>
- To: wayne.mcgill@xxxxxxxx
- Date: Tue, 13 Mar 2007 19:01:28 +0200
Hello,
This information is also available via ALL_TAB_PRIVS dictionary table. For
example:
select count(*)
from dba_tab_privs
where table_name in ( select sequence_name from dba_sequences )
From the documentation:
TABLE_NAME - Name of the object. The object can be any object, including
tables, packages, indexes, sequences, and so on.
On 3/13/07, Mcgill, Wayne CIV NAVAIR 5, , 111F <wayne.mcgill@xxxxxxxx>
wrote:
I would like to find out which users have been granted SELECT
on Sequences. I have used the tables like ALL_TAB_PRIVS and
ALL_COL_PRIVS to find out privileges for tables and columns
and ALL_USERS to find out all users but I have not found
anywhere to find information about Sequences.
THANKS, Wayne
--
//www.freelists.org/webpage/oracle-l
--
Best regards,
Edgar Chupit
callto://edgar.chupit
Other related posts:
