RE: pub synonyms

From: William Rogge <William_Rogge_at_voltek.com>
Date: Mon, 06 Aug 2001 07:29:41 -0700
Message-ID: <F001.003615F9.20010806070559@fatcity.com>

a public synonym is only an easier way to reference an object. It has nothing to do with user access to the directed object.

We use synonyms so our users do not need to know the OWNER of the object in there references. The OWNER still needs to grant the dml access to the role or user so the user can manipulate the object.

-----Original Message-----
From: prasad maganti [SMTP:prasadm_g_at_yahoo.com] Sent: Monday, August 06, 2001 10:11 AM

To:     Multiple recipients of list ORACLE-L
Subject:        pub synonyms

hi lists

does a user need any grants on public synonym for dml operations.

or

as it is a public synonym any user can do any thing on that (without any grants from the owner)

reg/prasa

---

Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: prasad maganti
  INET: prasadm_g_at_yahoo.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_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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: William Rogge
  INET: William_Rogge_at_voltek.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_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).

Received on Mon Aug 06 2001 - 09:29:41 CDT