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