Grant Method (Database)

SQL-DMO

Syntax

object.Grant( Privilege , GranteeNames )

Parts

object

Expression that evaluates to an object in the Applies To list

Privilege

Long integer that specifies one or more database permissions as described in Settings

GranteeNames

SQL-DMO multistring listing users or roles

Prototype (C/C++)

HRESULT Grant(
SQLDMO_PRIVILEGE_TYPE iPrivileges,
SQLDMO_LPCSTR GranteeNames);

Settings

Set Privilege using these SQLDMO_PRIVILEGE_TYPE values.

Constant	Value	Description
SQLDMOPriv_AllDatabasePrivs	130944	Grant all database permissions to the users or roles listed
SQLDMOPriv_CreateDatabase	256	Grant the execute permission for the CREATE DATABASE statement
SQLDMOPriv_CreateDefault	4096	Grant the execute permission for the CREATE DEFAULT statement
SQLDMOPriv_CreateFunction	65366	Can create and own UserDefinedFunction objects
SQLDMOPriv_CreateProcedure	1024	Can create and own StoredProcedure objects
SQLDMOPriv_CreateRule	16384	Grant the execute permission for the CREATE RULE statement
SQLDMOPriv_CreateTable	128	Grant the execute permission for the CREATE TABLE statement
SQLDMOPriv_CreateView	512	Grant the execute permission for the CREATE VIEW statement
SQLDMOPriv_DumpDatabase	2048	Grant permission to back up database
SQLDMOPriv_DumpTable	32768	Maintained for compatibility with previous versions of SQL-DMO
SQLDMOPriv_DumpTransaction	8192	Grant permission to back up the database transaction log

Remarks

Granting permissions to database users and roles using the Grant method of the Database object requires appropriate permissions. The Microsoft® SQL Server™ 2000 login used for SQLServer object connection must be a member of the system-defined role sysadmin.

For more information about setting multistring parameters, see Using SQL-DMO Multistrings.