This document is archived and information here might be outdated. Recommended version. |
Revokes privileges for the database user.
[Visual Basic .NET] Public Sub Revoke ( _ ByVal UserName As String, _ ByVal privileges As Integer _ )
[C#] public void Revoke ( string UserName, int privileges );
[C++]
HRESULT Revoke(
BSTR UserName,
long privileges
);
[C++]
Parameters UserName [in]
UserName is a parameter of type BSTR privileges [in]
privileges is a parameter of type long
The esriSQLPrivilege enumeration defines privieges that that can be revoked with ISQLPrivilege:
Enumeration esriSQLPrivilege | SQL Privileges |
---|---|
1 - esriSelectPrivilege |
Select |
2 - esriUpdatePrivilege |
Update |
4 - esriInsertPrivilege |
Insert |
8 - esriDeletePrivilege |
Delete |
The values may be bitwise OR'd together if more than one priviege applies (note that this is equal to summing the integer values). The dataset name could be a feature dataset, in which case the user would no longer have privileges on the contents of the feature dataset.