CREATE USER <user_name> [IDENTIFIED BY <password>][option];

The standard SQL statement to create a new user is shown as above. The IDENTIFIED BY is used only if you want to create database user that is authenticated by the DBMS. If you use Operating Authentication, the IDENTIFIED BY can be left empty. CREATE USER is the least used command in SQL statment because most database vendor will provide GUI intergace to database administator to manage the user login. Some database vendor such as Microsoft SQL Server don't even support the CREATE USER command.