Export (0) Print
Expand All

Viewing Logins

SQL Server 2000

  New Information - SQL Server 2000 SP3.

View Microsoft® SQL Server™ logins to determine if a user or Microsoft Windows NT® 4.0 or Windows® 2000 group has permission to connect to an instance of SQL Server, and to identify which databases the login can access. Also, view a login before removing it to see which database users must be removed; it is not possible to remove a login without first removing the associated users.

You can view:

  • Users in each database associated with the login.

  • Default database and language the login uses when the user first connects to an instance of SQL Server.

  • Windows NT 4.0 or Windows 2000 security identifier (SID).

    Note  It is not possible to view the password of any login unless the password is NULL. Passwords are encrypted when stored in SQL Server.

    Security Note  To protect against unauthorized access, do not assign a NULL password to a SQL Server login.

To view a SQL Server login or Windows user or group

Transact-SQL

Enterprise Manager

SQL-DMO

Show:
© 2014 Microsoft