Open topic with navigation

SITEPERMISSION (4.0SP9)

Top
Primary Key
Foreign Key Fields
Fields
Indexes
Triggers

Stores the flattened version of a system role application user's site permissions. This table was created so that the sql would not have to walk the site hierarchy when querying on site permissions.

Primary Key
Primary Key	Field Type
ID	uniqueidentifier

Foreign Key Fields
Foreign Key	Field Type	Null	Notes	Description
SYSTEMROLEID	uniqueidentifier	false	SYSTEMROLE.ID	FK to SYSTEMROLE
SITEID	uniqueidentifier	false	SITE.ID	FK to SITE
SYSTEMROLEAPPUSERID	uniqueidentifier	false	SYSTEMROLEAPPUSER.ID	FK to SYSTEMROLEAPPUSER
APPUSERID	uniqueidentifier	false	APPUSER.ID	FK to APPUSER

Fields
Field	Field Type	Null	Notes	Description
SYSTEMROLENAME	nvarchar(255)	false	''
SITENAME	nvarchar(1024)	false	''

Indexes
Index Name	Field(s)	Unique	Primary	Clustered
IX_SITEPERMISSION_APPUSERID	APPUSERID	False	False	False
IX_SITEPERMISSION_SITEID	SITEID	False	False	False
IX_SITEPERMISSION_SYSTEMROLEAPPUSERID	SYSTEMROLEAPPUSERID	False	False	False
IX_SITEPERMISSION_SYSTEMROLEID	SYSTEMROLEID	False	False	False
PK_SITEPERMISSION	ID	True	True	True

Triggers
Trigger Name	Description
TR_SITEPERMISSION_AUDIT_ETLDELETEDID