Message-Id: <10736.126114@fatcity.com> From: "Koivu, Lisa" Date: Tue, 9 Jan 2001 08:50:17 -0500 Subject: RE: Find out what sys privileges a user has This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C07A43.1A43BEBE Content-Type: text/plain Look in the following tables: dba_sys_privs dba_role_privs dba_tab_privs Lisa Rutland Koivu Oracle Database Administrator Qode.com 4850 North State Road 7 Suite G104 Fort Lauderdale, FL 33319 V: 954.484.3191, x174 F: 954.484.2933 C: 954.658.5849 http://www.qode.com "The information contained herein does not express the opinion or position of Qode.com and cannot be attributed to or made binding upon Qode.com." -----Original Message----- From: John Dunn [mailto:john.dunn@sefas.co.uk] Sent: Tuesday, January 09, 2001 6:56 AM To: Multiple recipients of list ORACLE-L Subject: Find out what sys privileges a user has How can I find out what privileges a user has on what sys packages, (from sqlplus command line) John . -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: john.dunn@sefas.co.uk 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@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). ------_=_NextPart_001_01C07A43.1A43BEBE Content-Type: text/html Content-Transfer-Encoding: quoted-printable RE: Find out what sys privileges a user has

Look in the following tables:

dba_sys_privs
dba_role_privs
dba_tab_privs

Lisa Rutland Koivu
Oracle Database Administrator
Qode.com
4850 North State Road 7
Suite G104
Fort Lauderdale, FL  33319

V: 954.484.3191, x174
F: 954.484.2933
C: 954.658.5849
http://www.qode.com

"The information contained herein does not = express the opinion or position of Qode.com and cannot be attributed to = or made binding upon Qode.com."


-----Original Message-----
From: John Dunn [mailto:john.dunn@sefas.co.uk]<= /FONT>
Sent: Tuesday, January 09, 2001 6:56 AM
To: Multiple recipients of list ORACLE-L
Subject: Find out what sys privileges a user = has


How can I find out what privileges a user has on what = sys packages, (from
sqlplus command line)

John
.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Dunn
  INET: john.dunn@sefas.co.uk

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