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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Create schema without a user?

Re: Create schema without a user?

From: Kenny Gump <kgump_at_mylanlabs.com>
Date: Tue, 2 Mar 1999 07:46:45 -0500
Message-ID: <36dbde03.0@news.mountain.net>


You can create a user account and not give it 'create session' privilege. Then to create a table in that schema you will need 'create any table' privilege. This is the prefered method for production tables any way.

Kenny Gump
OCP 7.3 DBA



Ken Rachynski wrote in message <36DB20F7.6852631F_at_cadvision.com>...
>Good day,
>
>I was wondering if it was at all possible to create a schema without
>having a user account for that schema.
>
>--
>Ken Rachynski
>Database Analyst
>krachyn_at_cadvision.com
><http://www.cadvision.com/krachyn>
>ICQ: 3113514
>
>
Received on Tue Mar 02 1999 - 06:46:45 CST

Original text of this message

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