Grant and Revoke SQL Server User Login without wizard

Vithal Wadje
Dec 09 2014
Code

1.6k
0
0

To Grant and Revoke SQL Server User Login witout wizard,SQL server provides the built in stored procedure named sp_grantlogin and sp_revokelogin,this store procedure takes the loginname as parameter

syntax for grant login

exec [sys].[sp_grantlogin] 'UserLoginName'

syntax for revoke login

exec [sys].[sp_revokelogin] 'UserLoginName'