| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Re: dictionary - privileges
You can query dba/all/user_tab_privs:
select * from dba_tab_privs where table_name = '<PROCEDURE/FUNCTION/SEQUENCE NAME>';
For Functions/Procedures, the privilege = 'EXECUTE', where as for SEQUENCE, it should be equal to 'SELECT' or 'ALTER'
HTH.
Gunawan Yuwono
Oracle DBA
Kansas City, MO
>--- Original Message ---
>From: "Shreepad Vaidya" <Shreepad.Vaidya_at_alltel.com>
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Date: 9/22/00 7:25:46 AM
>
>
>
>Hi,
>Check out for dba_sys_privs, user_sys_privs for execute privilege
on
>procedures and functions.
>
>For views
> check dba_tab_privs , user_tab_privs for select permissions
on
>base tables.
>
>If you are looking out for the last number allocated by the
>sequences.........
>look for dba_sequences ,user_sequences (column :------last_number
)
>
> Hope this helps.
> shreepad
>
>
>
>
>
>To: Shreepad Vaidya/IN/ALLTELCORP, ORACLE-L_at_fatcity.com AT
> INTERNET_at_CCMAIL
>cc:
>
>
>
>Which of the dictionary views keep privilege info on execution
of
>functions
>and use of sequences?
>
>TIA
>Anton Reish
>
>
>----------------------------------------------------------------------
>--------
>CONFIDENTIALITY NOTICE: If you have received this e-mail in
error,
>please immedi
>ately notify the sender by e-mail at the address shown. This
e-mail
>transmissio
>n may contain confidential information. This information is
intended
>only for t
>he use of the
> individual(s) or entity to whom it is intended even if addressed
>incorrectly.
>Please delete it from your files if you are not the intended
>recipient. Thank y
>ou for your compliance.
>
>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Reish, Anton N28
> INET: Anton.Reish_at_CIGNA.COM
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing
Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru')
and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).
You may
>also send the HELP command for other information (like subscribing).
>
>
>
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Shreepad Vaidya
> INET: Shreepad.Vaidya_at_alltel.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing
Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru')
and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).
You may
>also send the HELP command for other information (like subscribing).
>
>
 |
 |