RE: Public Privileges on system tables?

From: Johnston, Tim <TJohnston_at_quallaby.com>
Date: Tue, 29 Jan 2002 09:31:17 -0800
Message-ID: <F001.003FEE11.20020129083533@fatcity.com>

Hi Ron...

I found some info in the reference guide...

PSTUBTBL
This table contains information on stubs generated by the PSTUB utility so that an Oracle Forms 3.0 client can call stored procedures in an Oracle database.

---

---

Note:
The contents of this table are intended only for use by the PSTUB utility.

---

---

I only found a couple references to user_privs... Looks like it was eliminated... I found it mentioned on a couple web pages... I also found out that there appears to be a view named user_privs created by older pupbld.sql... It was based on the user_profile table...

HTH
Tim

-----Original Message-----
Sent: Tuesday, January 29, 2002 8:10 AM
To: Multiple recipients of list ORACLE-L

Hello Ron

I checked our 7.3.4 DB (on NT) and did not find these tables. I think that they may belong to a product that use these tables and so everyone who uses this product need them.

Yechiel Adar, Mehish Computer Services
adary_at_mehish.co.il

> -----Original Message-----
> From: Smith, Ron L. [SMTP:rlsmith_at_kmg.com]
> Sent: Mon, January 28, 2002 6:56 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Public Privileges on system tables?
>
> I have two tables, sys.pstubtbl and sys.user_privs that have grants to
> public for insert, update, and delete. Our auditors are wondering why.
> I don't really want to remove the privs without knowing why. This is an
> old
> 7.3.4 instance. Any ideas?
>
> Ron Smith
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Smith, Ron L.
> INET: rlsmith_at_kmg.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).
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> This e-mail was scanned by the eSafe Mail Gateway
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
  INET: adary_at_mehish.co.il

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: Johnston, Tim
  INET: TJohnston_at_quallaby.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 Tue Jan 29 2002 - 11:31:17 CST