Skip to content

sp-grantdbaccess-transact-sql.md

Latest commit

 

History

History
79 lines (61 loc) · 3.67 KB

sp-grantdbaccess-transact-sql.md

File metadata and controls

79 lines (61 loc) · 3.67 KB
title sp_grantdbaccess (Transact-SQL) | Microsoft Docs
ms.custom
ms.date 06/10/2016
ms.prod sql-non-specified
ms.reviewer
ms.suite
ms.technology
database-engine
ms.tgt_pltfrm
ms.topic language-reference
f1_keywords
sp_grantdbaccess
sp_grantdbaccess_TSQL
dev_langs
TSQL
helpviewer_keywords
sp_grantdbaccess
ms.assetid 3eb09513-03f1-42f8-9917-3a1f3a579bec
caps.latest.revision 33
author BYHAM
ms.author rickbyh
manager jhubbard

sp_grantdbaccess (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx_md]

Adds a database user to the current database.

Important

[!INCLUDEssNoteDepFutureAvoid] Use CREATE USER instead.
Applies to: [!INCLUDEssNoVersion] ([!INCLUDEssKatmai] through current version).

Topic link icon Transact-SQL Syntax Conventions

Syntax

  
sp_grantdbaccess [ @loginame = ] 'login'  
    [ , [ @name_in_db = ] 'name_in_db' [ OUTPUT ] ]

Arguments

[ @loginame = ] **'**login '
Is the name of the Windows group, Windows login or [!INCLUDEssNoVersion] login to be mapped to the new database user. Names of Windows groups and Windows logins must be qualified with a Windows domain name in the form Domain\login; for example, LONDON\Joeb. The login cannot already be mapped to a user in the database. login is a sysname, with no default.

[ @name_in_db=] 'name_in_db' [ OUTPUT]
Is the name for the new database user. name_in_db is an OUTPUT variable with a data type of sysname, and a default of NULL. If not specified, login is used. If specified as an OUTPUT variable with a value of NULL, @name_in_db is set to login. name_in_db must not already exist in the current database.

Return Code Values

0 (success) or 1 (failure)

Remarks

sp_grantdbaccess calls CREATE USER, which supports additional options. For information about creating database users, see CREATE USER (Transact-SQL). To remove a database user from a database, use DROP USER.

sp_grantdbaccess cannot be executed within a user-defined transaction.

Permissions

Requires membership in the db_owner fixed database role or the db_accessadmin fixed database role.

Examples

The following example uses CREATE USER to add a database user for the Windows login Edmonds\LolanSo to the current database. The new user is named Lolan. This is the preferred method for creating a database user.

CREATE USER Lolan FOR LOGIN [Edmonds\LolanSo];  
GO

See Also

Security Stored Procedures (Transact-SQL)
CREATE USER (Transact-SQL)
DROP USER (Transact-SQL)
System Stored Procedures (Transact-SQL)