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

Jubril wrote:

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