Administer Login Security Using System Procedures

You can administer integrated security from Windows.

For the full syntax for these procedures, see the procedure names in the Reference Manual: Procedures.

• Assigning Trusted Connection Permissions
  Assign permissions to Windows users and groups that access Adaptive Server over trusted connections.
• Display the Current Registry Values
  To display the current settings for the Registry values, use sp_loginconfig.
• Display Permissions and User Names
  To display the current permissions and mapped user names for both Windows users and groups, use sp_logininfo.
• Revoke Permissions Granted with sp_grantlogin
  Use sp_revokelogin or revoke to revoke permissions that were granted with sp_grantlogin.