Posted by nigelrivett on 10/16/06 16:33
You create a role in the database then add users/roles to that role as
you say.
sp_grantdbaccess is used to allow users access to the database whereas a
role is a means of allowing permissions to be allocated to all users in
that role.
You can though administer via nt roles which may be the sort of thing
you are looking for.
www.nigelrivett.net
*** Sent via Developersdex http://www.developersdex.com ***
Navigation:
[Reply to this message]
|