Re: Privileges on Sequences
- From: "Gints Plivna" <gints.plivna@xxxxxxxxx>
- To: wayne.mcgill@xxxxxxxx
- Date: Tue, 13 Mar 2007 19:00:41 +0200
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@xxxxxxxx>:
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
