Smartsite Documentatie > Advanced > Developer > Database changes > Content access > New trigger for Contents

New trigger for Contents

Release 1.0 - ...

Inheritance of access on "restricted" items is not handled by the cms, because Smartsite 5 didn't check access on item level. The database should make shure restricted items inherit the access privileges of their parent folder.

SQL CopyCode image Copy Code 
CREATE TRIGGER [dbo].[TR_InsertContentsRestrictedItem] ON [dbo].[Contents]
 FOR INSERT
AS
BEGIN
 SET NOCOUNT ON
 INSERT INTO UserGroupContentAccess (ContentNumber, GroupNumber, AccessType, AccessLevel)
 SELECT i.nr AS ContentNumber, ug.GroupNumber, 2 AS AccessType, ug.AccessLevel
  FROM Inserted i
  JOIN Contents c ON c.nr=i.parent
  JOIN UserGroupContentAccess ug ON (ug.ContentNumber=c.nr AND ug.AccessType=2)
  WHERE i.Restricted=1 AND i.Folder=0
END

Make sure the correct accesstype is used: BrowseAccess, which is usually 2.

Advanced