August 19, 2008 at 1:49 am
Hi Guys,
I have had a look through the scripts archive but have had no luck in finding something that can perform extensive account auditing, as I need to report on:
* active/deactive user accounts
- account password policy
- if password expiration is enforce
* db access (readonly/readwrite)
* default database
* server role mapping
* user mapping
Can anyone recommend suitable scripts that might be able to address some of these objectives?
Or is there an GUI utility I could use that will generate the SQL syntax to perform what i am after?
Any assistance on this would be much appreciated
August 19, 2008 at 2:01 am
Are you looking for a report of how it looks now, or are you looking to capture changes?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 19, 2008 at 2:09 am
I am looking to redirect the output to a text file which can then be later used to create a report.
I don't need to have a single script that performs all of these functions (this would overly complicate things I would imagine) Individual scripts would be handy.
August 20, 2008 at 11:00 pm
I don't know about scripts, but there are a few commands you can run that would return the information (just not necessarily in the format you want):
sp_helplogins
sp_helprotect
select * from master.sys.server_principals
select * from sys.sql_logins
MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply