August 27, 2009 at 12:33 pm
how to findout password policies?
August 27, 2009 at 12:36 pm
Look Up BOL.
Cheers,
J-F
August 27, 2009 at 5:30 pm
How to find out password policies for all users in a server.
I need the query to get the password policies of all users in a server.
August 27, 2009 at 6:22 pm
This set in the server properties as a default. For each user, you can see the properties of each user.
August 27, 2009 at 6:44 pm
my manager told me that collect passwordpolicies of the all users of all databases in the server.
how will i do?
August 27, 2009 at 9:45 pm
Start here:
http://msdn.microsoft.com/en-us/library/ms161959.aspx
It would help if you took the time to do some research ahead of time. This information is also available in BOL.
August 28, 2009 at 10:05 am
thanks got it............
sys.sql_logins
June 17, 2011 at 11:14 am
Old thread but came across it looking for policy posts. I did blog post on local password policies and using Policy-Based Management. Hope it helps someone at some point: http://sqlchicken.com/2011/05/policy-based-management-and-local-password-policy/[/url]
=============================================================
/* Backups are worthless, Restores are priceless */
Get your learn on at SQL University!
Follow me on Twitter | Connect on LinkedIn
My blog: http://sqlchicken.com
My book: Pro Server 2008 Policy-Based Management
June 24, 2011 at 7:43 am
Follow this link found it helpful. http://www.sqlservercentral.com/scripts/Security/73511/
“When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply