Postgres Plus Advanced Server Oracle Compatibility Developer's Guide :
CREATE USER -- define a new database user account
CREATE USER name IDENTIFIED BY password
CREATE USER adds a new user to a Postgres Plus Advanced Server database cluster. You must be a database superuser to use this command.
When the CREATE USER command is given, a schema will also be created with the same name as the new user and owned by the new user. Objects with unqualified names created by this user will be created in this schema.
The name of the user.
Sets the user’s password. The password can be changed later using ALTER USER.
The maximum length allowed for the user name and password is 63 characters.
Create a user named, john.
CREATE USER john IDENTIFIED BY abc;