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

If myschema is the schema owner for an application then the public synonym is appropriate, otherwise it would be better to create a private synonym for the user to point to a specific schema.

Lucia

-----Original Message-----
From: john.dunn_at_sefas.co.uk [mailto:john.dunn_at_sefas.co.uk] Sent: Friday, August 04, 2000 4:11 AM
To: ORACLE-L_at_fatcity.com
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).


--- Internet Message Header Follows ---
Received: from newsfeed.cts.com (209.68.192.199)
	by prophet.com (FirstClass Mail Server v5.11)
	transient id 66; 4:21:52 AM -0800
Received: from fatcity.UUCP (uucp_at_localhost)
	by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id EAA20750;
	Fri, 4 Aug 2000 04:13:25 -0700 (PDT)
Received: by fatcity.com (04-May-2000/v1.0f-b69/bab) via UUCP id 001A2D48;
Fri, 04 Aug 2000 03:10:47 -0800
Message-ID: <F001.001A2D48.20000804031047_at_fatcity.com>
Date: Fri, 04 Aug 2000 03:10:47 -0800
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
X-Comment: Oracle RDBMS Community Forum
X-Sender: John Dunn <john.dunn_at_sefas.co.uk>
Sender: root_at_fatcity.com
Reply-To: ORACLE-L_at_fatcity.com
Errors-To: ML-ERRORS_at_fatcity.com
From: John Dunn <john.dunn_at_sefas.co.uk>
Subject: Another newbie question about roles...and synonyms.
Organization: Fat City Network Services, San Diego, California
X-ListServer: v1.0f, build 69; ListGuru (c) 1996-2000 Bruce A. Bergman
Precedence: bulk
Mime-Version: 1.0
Content-Type: text/plain