Oracle Databases - Adding users

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Adding users

Jubril

2006-02-20, 3:24 am

pls how do i add users to the database using just sql

Michael Austin

2006-02-20, 3:24 am

Jubril wrote:

> pls how do i add users to the database using just sql
>
>

try reading the manuals - and a google search will certainly show you LOTS of
examples.

user creating a new user must have CREATE USER priv - if you don't, ask your DBA
for assistance.

CREATE USER username
IDENTIFIED {BY somepassword | EXTERNALLY}
[DEFAULT TABLESPACE sometablespace]
[TEMPORARY TABLESPACE sometemptablespace]
[QUOTA {integer [K|M] | UNLIMITED} ON sometablespace] ...
[PROFILE someprofile]

--
Michael Austin.
DBA Consultant
Donations welcomed. Http://www.firstdbasource.com/donations.html
:)

Sponsored Links