Tuesday, March 6, 2012

Adding Multiple Users to Database

In the users section of a database, I can select multiple users and
delete them from being able to access the DB in one keystroke (or so).
Can I do the reverse? If I deleted everyone, is there an SP or a
location that I can select multiple users and grant them access to the
DB quickly?
Thus far, all I've found is to select each user one at a time and give
them "public" access to the database.
(It's a good thing we are not a big company! I tried to restrict
access to all but a couple users to a particular DB only to discover
that I had the wrong DB selected. I had to add each user back in
manually.)
Thanks!
-TimothyConsider using NT group membership to the database.
See sp_grantdbaccess in Books Online;
sp_grantdbaccess
Adds a security account in the current database for a Microsoft SQL
Server login or Microsoft Windows NT user or group, and enables it to be
granted permissions to perform activities in the database.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

No comments:

Post a Comment