Export (0) Print
Expand All

sys.sql_logins (Transact-SQL)

Returns one row for every SQL Server authentication login.

Applies to: SQL Server (SQL Server 2008 through current version), Azure SQL Database.

Column name

Data type

Description

<inherited columns>

--

Inherits from sys.server_principals.

is_policy_checked

bit

Password policy is checked.

is_expiration_checked

bit

Password expiration is checked.

password_hash

varbinary(256)

Hash of SQL login password.

For a list of columns that this view inherits, see sys.server_principals (Transact-SQL).

Any SQL Server authentication login can see their own login name, and the sa login. To see other logins, requires ALTER ANY LOGIN, or a permission on the login.

The visibility of the metadata in catalog views is limited to securables that a user either owns or on which the user has been granted some permission. For more information, see Metadata Visibility Configuration.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft