click below
click below
Normal Size Small Size show me how
SQL Server login prm
SQL Server login permissions
Question | Answer |
---|---|
sp_addlogin | Creates a new login that allows users to connect to SQL Server using SQL Server authentication |
sp_grantlogin | Allows a Windows NT/2000 user account or group to connect to SQL Server using Windows authentication |
sp_droplogin | Drops an SQL Server login |
sp_revokelogin | Drops a Windows NT/2000 login/group from SQL Server |
sp_denylogin | Prevents a Windows NT/2000 login/group from connecting to SQL Server |
sp_password | Adds or changes the password for an SQL Server login |
sp_helplogins | Provides information about logins and their associated users in each database |