Grant Access to MSDE DB using Windows Group

Written by James McDonald

November 12, 2007

Trying to get an MSDE going with the SQL gui. These are my personal notes.

osql -U sa -S SERVER\INSTANCE
Password: ******

1. Give the group the ability to login to the MSDE Instance

use master
go
EXEC sp_addlogin ‘DOMAIN\domainGroup’
go

2. Grant Access to DB (still won’t be able to edit tables / data)
use dbname
go
exec sp_grantdbaccess ‘DOMAIN\domainGroup
go
Granted database access to ‘DOMAIN\domainGroup’

3. Give the group admin access to the db to allow editing etc.
EXEC sp_addrolemember ‘db_owner’ , ‘DOMAIN\domainGroup’
go
‘DOMAIN\domainGroup’ added to role ‘db_owner’.

0 Comments

Submit a Comment

Your email address will not be published. Required fields are marked *

You May Also Like…