August 24, 2009 at 9:21 pm
Hello,
I am trying to avoid a maintenance nightmare to add 100 users to a sql server 2005 so they can access the database for an application. The server where the database resides is NOT on the NT domain. I need to track changes by userid in the database. What is the best practice for managing access to this application/database.
August 24, 2009 at 9:47 pm
Not sure why this would be a maintenance nightmare, you have to add those users somewhere so they can be managed. Normally, that would be done through AD and you would use a domain group in SQL Server.
Since you are not on a domain - then you need to use SQL Accounts. What i would do is create a role, setup the appropriate permissions on the role, then add each login and add the user to the role in that database.
I guess you could also try adding a local group on the server, then add your users to the local group - but then you have to manage the users on the local machine. Now that would be a maintenance nightmare - in my opinion.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply