Re: Privileges on Sequences

From: Gints Plivna <gints.plivna_at_gmail.com>
Date: Tue, 13 Mar 2007 19:00:41 +0200
Message-ID: <6e49b6d00703131000w3b7adb54nc814181a65351ad2@mail.gmail.com>

SQL> select user from dual;

USER

GINTS Elapsed: 00:00:00.00
SQL> create sequence seq;

Sequence created.

Elapsed: 00:00:03.03
SQL> grant select on seq to otheruser
2 /

Grant succeeded.

Elapsed: 00:00:00.07
SQL> select * from all_tab_privs where TABLE_NAME = 'SEQ';

GRANTOR                        GRANTEE
------------------------------ ------------------------------
TABLE_SCHEMA                   TABLE_NAME
------------------------------ ------------------------------
PRIVILEGE                                GRA HIE
---------------------------------------- --- ---
GINTS                          OTHERUSER
GINTS                          SEQ
SELECT                                   NO  NO

Gints Plivna
http://www.gplivna.eu

2007/3/13, 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 - 12:00:41 CDT