Re: dictionary - privileges

From: Shreepad Vaidya <Shreepad.Vaidya_at_alltel.com>
Date: Fri, 22 Sep 2000 1:25 -0500
Message-Id: <10626.117626@fatcity.com>

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

From: ORACLE-L_at_fatcity.com AT INTERNET on 09/21/2000 11:45 AM

To: Shreepad Vaidya/IN/ALLTELCORP, ORACLE-L_at_fatcity.com AT

INTERNET_at_CCMAIL
cc:

Subject: dictionary - privileges

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). Received on Fri Sep 22 2000 - 01:25:17 CDT