Desk Access login Problem

Frappe Framework Permissions
1

Hi,
I removed the read role permission on Kanban Board, now I can’t access my erpnext desk.Kindly how can I go about this?
This is the message am getting when I login: “No permission to read Kanban Board”
Thanks

2

Login as Administrator and assign the same role to your user. It should be fixed then.

3

I can’t access the desk as an administrator too

4

Do you have recent backup ? If yes, then import it and it should solve you problem because Permissions are stored on database.

5

I only have today’s backup, yet the issue occurred 2 days ago. Thanks

6

Are you able to open any DocType or so from the url ?
your_site:port/desk#permission-manager/Kanban%20Board
If so, open it up and try to restore the original permission from the provided button on the page.

As a last resort you can do the following (Note:- Its highly volatile)

Try running this query from bench console or bench mariadb console -

update `tabDocPerm` set read=1 where parent='Kanban Board';
7

@cha it means you should take backup

8

Could this lead to loss of other modified doctypes?

9

Thanks

10

As far as I can understand this is setting Read permissions for all roles who are permitted some operation on Kanban Board. This should not affect any DocType.

11

Yes it is. Thanks

12

True that. This will not have any adverse effect as it is just changing the value of a column to its original state. The ‘Note’ was just a precautionary suggestion, as one should not rely on making changes to db no matter what (hence last resort). Were you able to solve the issue ?

2 Likes
13

I will let you know once I try. Thanks Zlash65

14

Just tried but didn’t work for me

15

This is the screenshot

51
51958×516 11.1 KB

16 
update `tabCustom DocPerm` set read=1 where parent='Kanban Board';

After running the above query, restart bench or bench clear-cache.