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
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:
Post a Comment