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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

;)
0
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Databases

From novice to tech pro — start learning today.