Re: Privileges on Sequences

From: <jherrick_at_igs.net>
Date: Tue, 13 Mar 2007 10:16:47 -0600
Message-ID: <20070313101647.oay7an7q9b2ck8kk@webmail.igs.net>

Look in

ALL_TAB_PRIVS
USER_TAB_PRIVS
DBA_TAB_PRIVS You'll see the sequence name under the table_name column and the grant

HTH Quoting "Mcgill, Wayne CIV NAVAIR 5, , 111F" <wayne.mcgill_at_navy.mil>:

> 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
>
>
>

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

Received on Tue Mar 13 2007 - 11:16:47 CDT