Saturday, February 23, 2013

How to create user in Oracle using plsql?

you could create a Oracle user using..


CREATE USER [USERNAME] IDENTIFIED BY [PASSWORD];

--grant user permission to create a session.

GRANT CONNECT to [USERNAME];


No comments:

Post a Comment