granting user access to db AND permission in role 1

[mpastore]

Hi,

I am using sp_grantdbaccess to grant a user access to a database. However, I also need to permit the user in a role, just like it is done in SQL log-in properties dialogue bix, except I need to do this all in t-sql.

Thanks Mike

Mike Pastore

Hats off to (Roy) Harper

 

[tman24m]

EXEC sp_addrole 'logonID'
GO

 

[tman24m]

oops, got ahead of myself there

USE db
GO
EXEC sp_grantdbaccess 'domainLogonName', 'dbLogonName-can be null if same as domain'
GO
EXEC sp_addrolemember 'roleName', 'dbLogonName'

 

[mpastore]

Actually it was sp_addrolemember, but you got me 1/2 way there, star for you!

Mike Pastore

Hats off to (Roy) Harper