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.