I have a Templates Cabinet which is owned by EDRMPROD and is_private is set to '1'.
I understand that the Cabinet shouldbe hidden from users but because I am not the owner I am not able to search it in order to add new Templates for use.
I was hoping to amend the is_private value to allow me to search for it. I have tried running the following query with a couple of variations on the 'is_private' value - i.e. 0, F, False but it has not worked. I have also tried using 'F' etc but that has not worked either.
UPDATE dm_cabinet OBJECT
set is_public = F
FROM dm_cabinet WHERE UPPER (object_name) = 'TEMPLATES'
Any advice you can offer to assist would be greatly appreciated.
