SQLzoo.net

Create a new user.

SQL Server
Give the new user permission to connect and to create their own tables etc.


Specific to SQL Server
CREATE USER

Old Style:

sp_addlogin 'scott', 'tiger';
CREATE DATABASE scott;
USE scott;
sp_changedbowner scott

Related links:

  • USERS