AnsweredAssumed Answered

Checking Rights to Document Properties Page

Question asked by Owen_R on Jul 19, 2012
Latest reply on Jul 23, 2012 by Dave
I have a portlet listing documents by project and folder. I want to link to the document's properties page via a column in this portlet. Using URL redirection I can get to the page correctly by building dynamic URLs in my data

e.g. http:/localhost/niku/app?action=dms.ProjectsFileProperty&fileId=XXXX

I would like to be able to disable the link if the user is not able to view the properties page. I've got a check to see if the user can see the file itself:
/* check for rights to file */
Case when exists
(SELECT  a.principal_id
FROM
cmn_sec_assgnd_obj_perm  a
WHERE  
a.object_id = 100 /* File is 100, folder is 200 */
AND a.principal_type = 'USER'  
AND a.permission_id IN ( 5, 4, 1 ) 
AND a.object_instance_id = f.id
AND a.principal_id = @WHERE:PARAM:USER_ID@)
Then 1 else 0 end as has_file_rights
does anybody know how I could specifically check for access to the properties page?

Thanks in advance

Owen

Outcomes