Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

password policies Expand / Collapse
Author
Message
Posted Thursday, August 27, 2009 12:33 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Monday, September 15, 2014 10:24 AM
Points: 424, Visits: 1,049
how to findout password policies?
Post #778593
Posted Thursday, August 27, 2009 12:36 PM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Thursday, September 19, 2013 6:00 AM
Points: 715, Visits: 2,706
Look Up BOL.

Cheers,

J-F
Post #778599
Posted Thursday, August 27, 2009 5:30 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Monday, September 15, 2014 10:24 AM
Points: 424, Visits: 1,049
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.
Post #778819
Posted Thursday, August 27, 2009 6:22 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 12:38 AM
Points: 33,267, Visits: 15,436
This set in the server properties as a default. For each user, you can see the properties of each user.






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #778834
Posted Thursday, August 27, 2009 6:44 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Monday, September 15, 2014 10:24 AM
Points: 424, Visits: 1,049
my manager told me that collect passwordpolicies of the all users of all databases in the server.

how will i do?
Post #778842
Posted Thursday, August 27, 2009 9:45 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 7:12 PM
Points: 23,397, Visits: 32,241
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.



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #778877
Posted Friday, August 28, 2009 10:05 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Monday, September 15, 2014 10:24 AM
Points: 424, Visits: 1,049
thanks got it............

sys.sql_logins
Post #779220
Posted Friday, June 17, 2011 11:14 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, July 11, 2014 8:30 AM
Points: 137, Visits: 648
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/

=============================================================
/* 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
Post #1127545
Posted Friday, June 24, 2011 7:43 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, September 10, 2014 12:57 AM
Points: 965, Visits: 1,160
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
Post #1131143
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse