SQL CREATE USER
The following command will create a user named Alex
with a password mySecretPass123
.
PostgreSQL
MySQL
SQL Server
CREATE USER Alex WITH PASSWORD 'mySecretPass123';
SQL Server
Microsoft’s documentation on the difference between login and user.
Oracle
Oracle handles users, schemas, and databases differently. Here is a link to Oracle’s explanation of high level objects like schemas, databases, etc