Table: user_group_acl
Article Id:
TABLE: USER_GROUP_ACL
Published:
21 Aug 2012, last updated 27 Nov 2013 16:01
Store Access Control List or ACL data. This defines access to individual objects - typically content items - based on user group membership.
|
Field |
Type |
Null |
Key |
Default |
Description |
|
id |
int(10) |
No |
Primary |
|
Primary |
|
acl_identity_name |
varchar(100) |
No |
|
|
The ACL identity |
|
group_id |
int(10) |
No |
|
0 |
The ID of the user group |
|
linked_id |
int(10) |
No |
|
0 |
The ID of the database object being included in this link |
|
creator_uid |
int(10) |
No |
|
0 |
The ID of the user account that created the ACL |
|
datecreated |
datetime |
No |
|
0000-00-00 00:00:00 |
The MySQL timestamp of when this ACL was created |
Indexes
|
Keyname |
Type |
Cardinality |
Field(s) |
Description |
|
PRIMARY |
PRIMARY |
0 |
id |
|
|
acl_identity_name |
Index |
n/a |
acl_identity_name |
|
|
group_id |
Index |
n/a |
group_id |
|
|
linked_id |
Index |
n/a |
linked_id |
|
|
acl_lookup |
Index |
n/a |
acl_identity_name, group_id, linked_id |
Principal index used in ACL lookups |