General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Is there any way to write a procedure that will return the names of NT user accounts & group memberships? I would like to write a sp that would run each night, collecting the names of all the NT users who have been added to a particular group, and storing them in a SQL table. I use SQL 6.5 and NT 4.
Our domain admins frequently add users to an NT group which gives them access to my database. But they can delete the account or remove the group membership, leaving me with no record of who got access to the db and when. I need something that will run as a scheduled task--I can't do this manually.
Thanks,
Ross
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only