The Grant method assigns a database permission or a list of permissions to one or more Microsoft® SQL Server™ 2000 users or roles.
object.Grant( Privilege , GranteeNames )
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
HRESULT Grant(
SQLDMO_PRIVILEGE_TYPE iPrivileges,
SQLDMO_LPCSTR GranteeNames);
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 |
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.