Assigning the "no access" permission to a folder

[durkine]

Hi,

I removed all access permissions for all roles in a folder by setting all roles to "no access".  Now none of the users can see the folder, even the admin user.

Is it possible to view/retrieve this folder again, even at a database level?

Thanks,
 

[mdjj]

Code:

I think I'm right in saying that at a database level folder and resource permissions are stored in the jiobjectpermission table. You'll probably find that for your folder (the uri column) the permissionMask column has values of 0 meaning each roleid in the recipientobjectid column has no access.



Simply change the permission mask back to a suitable value for each role (probably 1 for administrator and 2 for role_user).

[mdjj]

Sorry that wasn't code, pasted it in the wrong field!!!

I think I'm right in saying that at a database level folder and resource permissions are stored in the jiobjectpermission table. You'll probably find that for your folder (the uri column) the permissionMask column has values of 0 meaning each roleid in the recipientobjectid column has no access.

Simply change the permission mask back to a suitable value for each role (probably 1 for administrator and 2 for role_user).

[durkine]

Thanks, I will try that.

 

[durkine]

Hi,

That worked, thank you.

Regards,