SQL Security Manager provides a graphical way to map Windows NT users and groups to SQL Server login IDs for integrated or mixed security. (If you are using standard security, use SQL Enterprise Manager to set up login IDs.)
SQL Security Manager also allows you to grant and revoke SQL Server privileges to Windows NT groups, including setting up SQL Server login IDs and passwords for the group and adding users to SQL Server databases. In addition, you can use SQL Security Manager to search for the SQL Server access permissions for a given Windows NT account.
For more information, choose one of the following topics:
Viewing Users with User Privilege
Viewing Users with System Administrator Privilege
Searching for Account Information