Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Create user with no privs but CREATE SESSION and he can see things in SYS?

Re: Create user with no privs but CREATE SESSION and he can see things in SYS?

From: <craig.drabik_at_gmail.com>
Date: 22 Aug 2006 12:04:10 -0700
Message-ID: <1156273450.892134.111980@p79g2000cwp.googlegroups.com> 






DA Morgan wrote:



> Go with Frank's answer but you should grant CREATE SESSION, not CONNECT.

> Also you not granted access to the TEMP tablespace which may be an issue

> depending on what you are doing.




Thanks.  I know I need to specify a temp tablespace and shouldn't grant
connect - done for this example for the sake of brevity.



Thanks again for the answers.
Received on Tue Aug 22 2006 - 14:04:10 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US