Is there a query that can run from a database to view the password policy?

Hello,

I have inherited a project for auditing to pull information on SQL users password expiration policy. Right now they believe it's 30 days and want to set it to 90 days. Is there a query that I can run to select this information?

Problems:
No server access, I can't connect via PuTTy or RDP. I can only connect via SQL.
Group policy is set for 90 days on all the other servers, this may not be communicating correctly to the GP?

I'll be on all day as no one that would be able to help me directly in the office is here, and if you need more information I can provide that to the best of my ability.
Joshua_MAsked:
Who is Participating?
 
PilouteCommented:
OK. I saw you posted in the SQL server zone too. I'll asume you are looking for SQL Server.

Here's what you are looking for :

http://www.sql-server-performance.com/articles/dba/Analyzing_SQL_Server_Permissions_p1.aspx

Cheers,
P
0
 
PilouteCommented:
Now that's cool ! How about telling us which database and version of it you use ?

;)
0
 
Joshua_MAuthor Commented:
Piloute,

Thanks for the link, I did find the last little bit of the answer I was looking for through another link there.
I didn't realize SQL used the group policy or the servers local security settings.
0
 
PilouteCommented:
Welcome. SQL Server 2005 changed lots of features... 2008 is more dba-friendly once you know 2005.

P
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.