Sunday, October 11, 2009

SQL - create user account

1. Execute commands as below to create login account
CREATE LOGIN deve1
WITH PASSWORD = 'deve1';
USE dbase_xxx;
CREATE USER deve1 FOR LOGIN deve1;
GO


2. Execute commands as below to assign user account to each database
use dbase_xxyy
exec sp_adduser deve1

3. Execute commands as below change grant / deny access rights to individual account
DENY UPDATE ON dbase_XXX..table_xxx to develop

No comments: