RE: Another newbie question about roles...and synonyms.

Check out the procedings at www.inoug.org. At the July, 2000, meeting Bob Swisshelm (Eli Lilly DBA) presented a paper showing how this can be done. I believe the title was "Implementing Security through Stored Procedures".

Tom Harleman
11080 Willowmere Dr.
Indianapolis, IN 46280
317-844-2884 Home
317-843-9122 Home Office

-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of John Dunn Sent: Friday, August 04, 2000 6:11 AM
To: Multiple recipients of list ORACLE-L Subject: Another newbie question about roles...and synonyms.

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_at_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_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).