Skip to Content
Nov 19, 2020 at 09:01 AM

Which role to retrieve password policy?



For a client, I try to get the password settings in order to check for complexity.

However I'm not able to get the sp_passwordpolicy values. Because when I run the command with the user sapsa on the user database, it says :

You must have the following permission to execute this command :'manage security configuration'.

Please contact a user with appropriate permission for help.

My question is which user do I need to retrieve the sp_passwordpolicy.

Do I need Sa, or the database owner role or which one?

And do I have to run the command for the user database or master?