Viewing Logins

Started by sukishan, Aug 18, 2009, 07:13 PM

Previous topic - Next topic

sukishan

Viewing Logins
  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.
A good beginning makes a good ending