RE: Public Privileges on system tables?
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).
RE: Public Privileges on system tables?
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).
Re: Public Privileges on system tables?
[EMAIL PROTECTED] wrote: >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 > i'm guessing that for at least the sys.user_privs it's so that when a user grants and privs on any of their objects they can insert a row, or if the change it update the row, or delete the row if they revoke it. i think that's where the system checks if access is allowed to anyone but the owner. i'm sure someone will correct me shortly.;-) -- -- Bill "Shrek" Thater ORACLE DBA [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. Never trust a program unless you have the source. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: bill thater 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).
