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 in Oracle 6

Re: CREATE USER in Oracle 6

From: Terry Ball <terry_ball_at_csgsystems.com>
Date: Thu, 09 Sep 1999 14:14:54 -0500
Message-ID: <37D8072E.66F8FCFB@csgsystems.com>


I just happen to have my old SQL Language Reference Manual at hand.

To create a user the syntax (in V6) is:

    grant connect to username;

You can also grant other privs at the same time by seperating them by a comma.

Terry

David Field wrote:

> I am trying to create a new user in an Oralce 6 database. The CREATE USER
> command will not work, and it has been suggested that the syntax for adding
> users is compleately different to 7. I have no documentation ! Anyone got
> any ideas ?
>
> Cheers
>
> Dave Field.
Received on Thu Sep 09 1999 - 14:14:54 CDT

Original text of this message

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