How do I create a user in Oracle 9i?

Question

Please tell me how to create user in Oracle 9i.

Answer 1

Use the following to create a user called "username", whose password is "password":

CREATE USER username IDENTIFIED BY password

Reference:

• http://download.oracle.com/docs/cd/B28359_01/server.111/b28286/statements_8003.htm