This document is archived and information here might be outdated.  Recommended version.

ISQLPrivilege Interface (ArcObjects .NET 10.8 SDK)
ArcObjects Help for .NET developers > ArcObjects Help for .NET developers > ArcObjects namespaces > Geodatabase > ESRI.ArcGIS.GeoDatabase > Interfaces > IS > ISQLPrivilege Interface
ArcGIS Developer Help

ISQLPrivilege Interface

Provides access to members for granting and revoking privileges to database users.

Product Availability

Available with ArcGIS Engine, ArcGIS Desktop, and ArcGIS Server.


Name Description
Method Grant Grants privileges for the database user.
Method Revoke Revokes privileges for the database user.
Read-only property SQLPrivileges The database privileges.

Classes that implement ISQLPrivilege

Classes Description
ESRIFDOAddressLocator (esriLocation) An address locator that uses the Esri geocoding engine developed prior to ArcGIS version 10.0.
ESRIGen2AddressLocator (esriLocation) An address locator that uses the Esri geocoding engine introduced in ArcGIS version 10.0.
FeatureClassName Esri Feature Class Name object.
FeatureDatasetName Esri Feature Dataset Name object.
GPToolboxName (esriGeoprocessing) Light-weight object referencing a geoprocessing toolbox.
LocatorName (esriLocation) Name object for a locator.
ObjectClassName Esri Object Class Name object.
RelationshipClassName Esri Relationship Class Name object.
SchematicDatasetName (esriSchematic) Schematic dataset name object.
TableName Esri Table Name object.


The ISQLPrivilege optional interface provides information about the permissions you have on a database object and also the ability to change the permissions for other users. It only applies to those datasets that are stored within an ArcSDE geodatabase. It applies to feature datasets, feature classes, tables, relationship classes, raster datasets, and raster catalogs.  ISQLPrivilege cannot be used on datasets contained within a feature dataset, as permissions are managed at the feature dataset level.

The esriSQLPrivilege enumeration defines values that can be used with ISQLPrivilege:

Enumeration esriSQLPrivilege SQL Privileges

1 - esriSelectPrivilege


2 - esriUpdatePrivilege


4 - esriInsertPrivilege


8 - esriDeletePrivilege


The values may be bitwise OR'd together if more than one privilege applies (note that this is equal to summing the integer values). For example, if the SQLPrivileges property returns a value of 9, this would mean that you have select and delete permission on the dataset, but not insert or update. A value of 15 indicates full privileges.

The last parameter on Grant is for specifying whether or not the user will have the ability to grant privileges to other users.

Address locators only support esriSelectPrivilege

See Also

IName Interface