sp_grantlogin (Transact-SQL)
TOC
Collapse the table of content
Expand the table of content
The document is archived and information here might be outdated

sp_grantlogin (Transact-SQL)

Creates a SQL Server login.

ms173449.note(en-US,SQL.90).gifImportant:
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Use CREATE LOGIN instead.

Topic link icon Transact-SQL Syntax Conventions


sp_grantlogin [@loginame=] 'login'

[ @loginame = ] 'login'

Is the name of a Windows user or group. The Windows user or group must be qualified with a Windows domain name in the form Domain\User; for example, London\Joeb. login is sysname, with no default.

0 (success) or 1 (failure)

sp_grantlogin calls CREATE LOGIN, which supports additional options. For information on creating SQL Server logins, see CREATE LOGIN (Transact-SQL)

sp_grantlogin cannot be executed within a user-defined transaction.

Requires ALTER ANY LOGIN permission on the server.

The following example uses CREATE LOGIN to create a SQL Server login for the Windows user Corporate\BobJ. This is the preferred method.

CREATE LOGIN [Corporate\BobJ] FROM WINDOWS;
GO
Show:
© 2016 Microsoft