Background

Sometimes either due to slow permissions or due to a bug in specific portal versions permissions must be added on an item manually. This article should walk through how to do this. Permissions are currently controlled through two tables:

For Individual accounts:

[IMATIS].[ITEM_USER]

For Roles:

[IMATIS].[ITEM_Role]

Manually adding permissions

Step 1: Locate Item ID and User ID / Role ID

ItemID    SELECT [ItemId],[Name] from imatis.ITEM

UserID    SELECT [userId],[UserName] from imatis.users

RoleId     SELECT [MGRID],[MGRName] from imatis.membergroups

Step 2: Insert Into the permissions table using User ID or Role ID found in previous step

UserID:

    insert into [Liberty].[IMATIS].[ITEM_USER]([ItemId],[UserId])

    Values (#ITEMID,#USERID)

RoleID:

    insert into [Liberty].[IMATIS].[ITEM_ROLE]([ItemId],[RoleId])

    Values (#ITEMID,#ROLEID)

If trying to copy an existing user's settings

In order to view existing permissions in human-readable format

Human Readable: 

  select a.ItemId, b.[name], c.[FullName] from imatis.Item_user as a

    inner join [IMATIS].[ITEM] as b on a.ItemId = b.ItemId

    Inner join [IMATIS].[USERS] as c on a.UserId = c.userid

    where a.userid = ##