September 14, 2005 at 6:46 am
Hello,
I am writing the scripts to extract informations from SQL Server to produce the monthly reports for the management.
1. I want to extract the registry permission of who have the full control, etc. The xp_regread does not show the users in the registry.
2. I want to get information on who have what kind of permissions on the data files.
3. Last of all, the information of who owns the service account.
I would appreciate if anyone can write scripts.
Thank you.
Regards,
Mike
September 14, 2005 at 1:55 pm
You want users that have full control over what?
Don't understand on what you mean by who owns service account.
To figure out what users have access to what data files are you talking sql server databases? or files on the machine?
September 14, 2005 at 2:09 pm
Sorry. I didn't make myself clear. I just want to extract the monthly information for the management.
I want to make the shortcut to access to information by running the scripts.
I am talking about the sql server database (data files).
Thank you.
Warm Regards.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply