User Mapping

Question

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

jvanderberg SSCertifiable Points: 6762 More actions · Answer 1

Generally, you would assign someone to one role. Specifically, the roles "datareader" and "denydatareader" counter each other.

Even better is to create a new role, and assign the specific permissions to that role. Then, add users to the role.

Jorge Segarra SSCrazy Points: 2571 More actions · Answer 2

USE [demodb]

GO

CREATE USER [testme] FOR LOGIN [testme]

GO

USE [demodb]

GO

EXEC sp_addrolemember N'db_accessadmin', N'testme'

GO

USE [demodb]

GO

EXEC sp_addrolemember N'db_backupoperator', N'testme'

GO

USE [demodb]

GO

EXEC sp_addrolemember N'db_datareader', N'testme'

GO

=============================================================
/* Backups are worthless, Restores are priceless */