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