how to hide Content Folder for a User

Mansi Sharma shared this question 3 months ago
Answered

Hi Team YF,


I have a question about how can i hide Content Folder for a User/User Group in YF 7.3.

I have given permissions for Sub folder and those are not showing up but the Mail folder still shows up for Users/User Group who don't have permissions to that content. Screen Shot attached.


Please let me know if there is any way to hide this Folder from Folder List.

Thanks,

Mansi Sharma.

Comments (4)

photo
1

Hi Mansi,

interesting problem, I've found that even though you can't set a top level content folder to be Private via the UI, it is actually possible with a little bit of backend action!

You will need to look into the ContentManagement table to learn what the ContentManagementID is for the top level folder you wish to hide. You can identify which row is the one you want by finding the folder's name in the column called "ContentTypeCode", however you will most probably find more than one row with your folder name in which case you only want the row that has the value 'INDEX' for the column called 'ContentCode'

Once you have the correct ContentManagementID you will also need to get the IpPerson of the user you wish to be allowed to see the private top level folder. You can find this in the Person table, and you can identify which row you want by finding the user's name in the FullName column.

Then all you have to do is insert a new record in the AccessLevel table as follows:

INSERT INTO AccessLevel 
VALUES (<insert your ContentManagementId here>,	'CONTENT', 'DELETE', 'PERSON', <insert your IpPerson here>)
And of course, you don't have to give the user the DELETE access permission, you could also give them EDIT or READ


You will to add a new record in the AccessLevel table for each user you want to add to the top folder's security list.


Finally, you will need to restart Yellowfin.


And as we tell all our clients who delve into the backend of their Yellowfin config database, don't forget to back it up immediately prior to your modifications.


I hope that works for you as well as it did for me!

Please let me know how it goes.


regards,

David

photo
1

Hi David,


Thanks a lot for the above solution but i want to add more to it.

When i followed the same steps - My top level content folder was still showing up. I investigated a bit and found the problem -

In ContentManagement table "LoginAccessCode" is set to "UNSECURE" by default. I updated the LoginAccessCode to "ACCESSLEVEL" for my ContentManagementId in ContentManagement table and here we go - It worked. Top Level content Folder is hidden for other users.


Thanks,

Mansi Sharma.

photo
1

you are absolutely correct, and my apologies for missing that step - I did it myself (there is no other way) but forgot it in my description to you.

Well done!

regards,

David

photo
1

Thanks David.