On the move:

I'm currently moving the following to their own blogs: Unix, HTML for Blogs, Perl & Java.
The links are on the left side.

Tuesday, July 29, 2008

Create a User

connect system/system

CREATE USER user3 -- define user name
IDENTIFIED BY pass3 -- assign password
DEFAULT TABLESPACE users -- assign tablespace for their work (select tablespace_name from dba_data_files;)
TEMPORARY TABLESPACE temp -- assign temp space for 'order bys'
QUOTA 0 ON SYSTEM -- allow no usage of this area
QUOTA UNLIMITED ON users -- allow as much as they need here
PROFILE clerk -- attach a profile
ACCOUNT LOCK
;

CREATE USER user3
IDENTIFIED BY pass3
TEMPORARY TABLESPACE temp
QUOTA 0 ON SYSTEM
QUOTA UNLIMITED ON users
PROFILE clerk
ACCOUNT LOCK
;

No comments:

Post a Comment