ST_OBJECTACLS
This table lists the access control lists for all objects.
Column | Field | Type | Length | Primary | Description |
---|---|---|---|---|---|
1 |
ServerID |
int |
4 |
Y |
Server ID |
2 |
ACLID |
int |
4 |
Y |
ACL ID |
3 |
ObjectID |
int |
4 |
N |
ID of object for which ACLs are for |
4 |
ClassID |
int |
4 |
N |
Class ID of object for which ACLs are for |
5 |
ContainerClassID |
int |
4 |
N |
Class ID for the container type |
6 |
Container |
int |
4 |
N |
1 if contianer, 0 if not |
7 |
Sequence |
int |
4 |
N |
Order for the group or user |
8 |
PermissionCode |
int |
4 |
Y |
Permission Code |
9 |
TypeName |
varchar |
32 |
N |
Type Name of object for which ACLs are for |
10 |
ContainerTypeName |
varchar |
32 |
N |
Type Name for the container type |
11 |
ID |
int |
4 |
N |
ID of user or group |
12 |
UserGroup |
varchar |
32 |
N |
Whether user or group |
13 |
GrantDeny |
varchar |
32 |
N |
Whether grant or deny |
Table Joins
Column | Primary Table | Primary Field | Foreign Table | Foreign Field |
---|---|---|---|---|
1 |
ST_CHANGEPACKAGES |
ServerID |
ST_OBJECTACLS |
ServerID |
2 |
ST_CHANGEPACKAGES |
ID |
ST_OBJECTACLS |
ObjectID |
1 |
ST_CRS |
ServerID |
ST_OBJECTACLS |
ServerID |
2 |
ST_CRS |
ID |
ST_OBJECTACLS |
ObjectID |
1 |
ST_FILES |
ServerID |
ST_OBJECTACLS |
ServerID |
2 |
ST_FILES |
ID |
ST_OBJECTACLS |
ObjectID |
1 |
ST_FOLDERS |
ServerID |
ST_OBJECTACLS |
ServerID |
2 |
ST_FOLDERS |
ID |
ST_OBJECTACLS |
ObjectID |
1 |
ST_GROUPS |
ServerID |
ST_OBJECTACLS |
ServerID |
2 |
ST_GROUPS |
ID |
ST_OBJECTACLS |
ID |
1 |
ST_PERMISSIONS |
ServerID |
ST_OBJECTACLS |
ServerID |
2 |
ST_PERMISSIONS |
ContainerClassID |
ST_OBJECTACLS |
ContainerClassID |
3 |
ST_PERMISSIONS |
PermissionCode |
ST_OBJECTACLS |
PermissionCode |
1 |
ST_PROJECTS |
ServerID |
ST_OBJECTACLS |
ServerID |
2 |
ST_PROJECTS |
ID |
ST_OBJECTACLS |
ObjectID |
1 |
ST_REQS |
ServerID |
ST_OBJECTACLS |
ServerID |
2 |
ST_REQS |
ID |
ST_OBJECTACLS |
ObjectID |
1 |
ST_SERVER |
ServerID |
ST_OBJECTACLS |
ServerID |
1 |
ST_TASKS |
ServerID |
ST_OBJECTACLS |
ServerID |
2 |
ST_TASKS |
ID |
ST_OBJECTACLS |
ObjectID |
1 |
ST_TOPICS |
ServerID |
ST_OBJECTACLS |
ServerID |
2 |
ST_TOPICS |
ID |
ST_OBJECTACLS |
ObjectID |
1 |
ST_TRACES |
ServerID |
ST_OBJECTACLS |
ServerID |
2 |
ST_TRACES |
ID |
ST_OBJECTACLS |
ObjectID |
1 |
ST_USERS |
ServerID |
ST_OBJECTACLS |
ServerID |
2 |
ST_USERS |
ID |
ST_OBJECTACLS |
ObjectID |
1 |
ST_VIEWS |
ServerID |
ST_OBJECTACLS |
ServerID |
2 |
STVIEWS |
ID |
STOBJECTACLS |
ObjectID |