sql - Password Policy and Authorization Matrix -


the main topic of question authorization matrix in context of sql server, searched in google couldn't find result , of got not clear understand. wanna know , how use it.

regarding password policies, found options change pass after login, etc. actual password policy , if how can script in t-sql? possible @ all?

not sure mean authorization matrix. please explain trying achieve.

regarding scripting out password options, yes, possible script them out. either use login window script out:

enter image description here

or directly use t-sql mentioned in link: https://technet.microsoft.com/en-us/library/ms161959(v=sql.120).aspx


Comments