Message-Id: <10579.113852@fatcity.com> From: "Rachel Carmichael" Date: Fri, 04 Aug 2000 13:41:04 GMT Subject: Re: Another newbie question about roles...and synonyms. nope -- one of my biggest complaints about roles is that you cannot create synonyms (it's considered an "object") you will have to either specify owner.object_name or create public synonyms >From: John Dunn >Reply-To: ORACLE-L@fatcity.com >To: Multiple recipients of list ORACLE-L >Subject: Another newbie question about roles...and synonyms. >Date: Fri, 04 Aug 2000 03:10:47 -0800 > >Can I create synonyms via a role? > >i.e. when I create a user I use a role. I want this user to be able to >refer >to objects in myschema using a synonym rather than myschema.object > >Is this possible? > >John > > >-- >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). ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com