By wdrupal on
I just installed node_privacy_byrole module becuase I need certain account roles to have full access to edit all nodes, even if they were not the authors (but not have access to everything on the site).
I enabled "edit" ability for all the nodes for that "editor" role, but only some of the nodes allow the editor role to edit them. Most of the nodes say "access denied" when I try to edit them with the "editor" role.
I uploaded the module to my modules directory, enabled it in 'modules' and then enabled it on its settings page. Is there anything else I need to do?
Has anyone else had this problem?
Comments
more problems
I decided to diable node_privacy_byrole and try "simple access" instead. But now the changes that node_privacy_byrole made are still there even after disabling it.
Does anyone know how to undo the changes made by node_privacy_byrole?
I just found this buried in the .module file (it should be in the readme...).
Does the following comment mean that I have to use the following SQL to get rid of this module?
INSERT INTO node_access (nid, gid, realm, grant_view, grant_update, grant_delete) VALUES (0, 0, 'all', 1, 0, 0)';
Do I have to manually use the first SQL statement to get the module to work correctly? (DELETE FROM node_access WHERE realm='all';)
The readme file for the module does not mention any of this.
Get rid of Access Denied with this line of SQL
wdrupal, thanks for pointing this out. I recently upgraded from 4.6.6 to 4.7.0 and disabled the node_privacy_byrole module because there isn't a 4.7 release yet.
The upgrade to 4.7 went OK until I found that anonymous users no longer had the ability to view any pages on the site. I suspected it had something to do with node_privacy_byrole and your post gave the answer.
In my case I have a number of records in the node_access table with the realm of "node_privacy_byrole_role" or "node_privacy_byrole_user". I executed this line of SQL:
Which added a record to the end of the table. This fixed the problem and anonymous users can once again view any pages. A potential benefit is leaving the node_privacy_byrole records in the table for later use.
Thanks
Thanks for posting a fix. I actually switched to the Simple Access module after having to reinstall the whole Drupal installation. Simple Access works without any problems now on a couple of my sites...
This module totally so not
This module totally so not does
I have a similar problem. With this sql line at least I got anybody to see the pages again. But roles I defined beside the admin to edit pages, which also edited the pages before I installed npbr can't edit text anymore. They were also disabled when I installed the module first.
How can I rollback this stuff...at least I have a backup from yesterday but is there anyway to solve this problem
---
Join the virtual march to stop global warming.
http://www.stopglobalwarming.org/marchers/?142067