Re: Privileges on Sequences

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_at_navy.mil> 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
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Best regards,
Edgar Chupit
callto://edgar.chupit

--
http://www.freelists.org/webpage/oracle-l