Re: help create a user in Oracle 8i?

From: Van Messner <vmessner_at_netaxis.com>
Date: Sun, 22 Aug 1999 10:38:48 -0400
Message-ID: <CXTv3.15623$x04.1024158@typ11.nn.bcandid.com>

create user NNNN
identified by PASSWORD
default tablespace USER_DATA
temporary tablespace USER_TEMP;

NNNN is the user name. PASSWORD is his password stored in the database. Default and temporary tablespaces should be specified. Otherwise you'll default to the System tablespace, a really bad idea. You can also add clauses for quota, profile and default role - see your Oracle documentation.

JS <jonua123_at_yahoo.com> wrote in message news:37BE2D57.79D361B1_at_yahoo.com...
> Anyone know the commands to create a user in Oracle 8i?
Received on Sun Aug 22 1999 - 09:38:48 CDT