Re: CREATE USER in Oracle 6

A copy of this was sent to "David Field" <davidf_at_rockdb.demon.co.uk> (if that email address didn't require changing) On Thu, 9 Sep 1999 17:15:34 +0100, you 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.
>
>
>

grant connect to <USERNAME> identified by <password>;

should work.

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Thu Sep 09 1999 - 11:47:01 CDT