Re: pub synonyms

From: OZKAN OZCAN <oozcan_at_tekstilbank.com.tr>
Date: Mon, 06 Aug 2001 07:42:06 -0700
Message-ID: <F001.00361655.20010806071137@fatcity.com>

Synonyms are only aliases to the objects which prevents user from writing the owner of the object.
On the other hand no grantship is assigned to anybody. So you have to give necessary grants
to the users that will use the synonym.

Ozkan.

                                                                                   
                                                                                   
                                  Gönderilen:               Multiple               
                            recipients of list ORACLE-L                            
                            <ORACLE-L_at_fatcity.com>                                 
  prasad maganti                  Bilgisine:                                       
 <prasadm_g_at_yahoo.com>            Konu:                                            
                            pub synonyms                                           
  Gönderen:                                                                        
 root_at_fatcity.com                                                                  
  06/08/2001 16:55                                                                 
                                                                                   
  Lütfen ORACLE-L adresine                                                         
 yanıtlayınız.                                                                     
                                                                                   
                                                                                   



     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: OZKAN OZCAN
  INET: oozcan_at_tekstilbank.com.tr

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:42:06 CDT