Re: Security question

From: <martyn.r.baker_at_uk.pwcglobal.com>
Date: Fri, 12 May 2000 09:47:45 +0100
Message-Id: <10495.105467@fatcity.com>

--0__=JIM3YSxmvvXkRUKH5zj8STHFF0FVECY8cp7iZRcE5KV8PvouaBbqkz3I
Content-type: text/plain; charset=us-ascii Content-Disposition: inline

Jack,
That is the method that I would use. You could further restrict what they can see in those tables by using views and giving them access to the views. Also when you create the users dont forget to change the default and temporary tablespaces to something other than the Oracle default of SYSTEM. Martyn

                                                                  
 (Embedded                                                        
 image moved   Jack van Zanen <nlzanen1_at_ey.nl>                    
 to file:      12/05/2000 10:06                                   
 pic23011.pcx)                                                    
                                                                  

Please respond to ORACLE-L_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc:
Subject: Security question

Hi All,

I was asked to create a few user accounts that only have select rights on a few tables.

What I plan to to is create a role that has select rights on those tables. grant this role including create session to these users and create public synonyms for these tables.

Is this the correct procedure or are there other/better methods.??

Jack

---

De informatie verzonden met dit E-mail bericht is uitsluitend bestemd voor de geadresseerde. Gebruik van deze informatie door anderen dan de geadresseerde is verboden. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is niet toegestaan. Ernst & Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden E-mail, noch voor tijdige ontvangst daarvan.

---

The information contained in this communication is confidential and may be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed and others authorised to receive it. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. Ernst & Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt.

---

--

Author: Jack van Zanen
  INET: nlzanen1_at_ey.nl

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

---

The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer.

--0__=JIM3YSxmvvXkRUKH5zj8STHFF0FVECY8cp7iZRcE5KV8PvouaBbqkz3I

Content-type: text/plain; name="pic23011.txt"
Content-Disposition: attachment; filename="pic23011.txt"
Content-transfer-encoding: 7bit

<binary content removed -- do not send binaries to the list> Received on Fri May 12 2000 - 03:47:45 CDT