From teci@oracle-dba.com Thu, 08 Mar 2001 20:03:28 -0800 From: "Joseph S. Testa" Date: Thu, 08 Mar 2001 20:03:28 -0800 Subject: Re: What or who is PUBLIC? Message-ID: MIME-Version: 1.0 Content-Type: text/plain I beg to differ, look at sql.bsq, quote: create role public / its right after the create user sys .... joe "Maser, Donna (SEA)" wrote: > > Ron, > > PUBLIC is not actually a ROLE, it is a 'user group'. > It always is available to ALL users in a database. > If used in reference to a synonym, privilege, role, > or subroutine (variable, constant, function, procedure) > of a package it means the synonym, privilege, role, > or subroutine is accessible to every database user. > > The other use of public is in reference to a rollback segment > within a parallel server database, where public means that > any instance requiring a rollback segment can use it . > > Donna > > -----Original Message----- > Sent: Thursday, March 08, 2001 2:22 PM > To: Multiple recipients of list ORACLE-L > > Can anyone point me to a paper or explanation of the Oracle role? called > PUBLIC? How do you manage permissions for PUBLIC? > > Ron Smith > Database Administration > rlsmith@kmg.com > > The information contained in this email is intended for the > personal and confidential use of the addressee only. It may > also be privileged information. If you are not the intended > recipient then you are hereby notified that you have received > this document in error and that any review, distribution or > copying of this document is strictly prohibited. If you have > received this communication in error, please notify Celltech > Group immediately on: > > +44 (0)1753 534655, or email 'is@celltech.co.uk' > > Celltech Group plc > 216 Bath Road, Slough, SL1 4EN, Berkshire, UK > > Registered Office as above. Registered in England No. 2159282 > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Maser, Donna (SEA) > INET: DonnaMaser@chiroscience.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@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). -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: teci@oracle-dba.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@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).