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 [EMAIL PROTECTED] > -----Original Message----- > From: Smith, Ron L. [SMTP:[EMAIL PROTECTED]] > 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
