Posted by agentrickard on December 10, 2007 at 12:34am
In the last week, I've helped two people deal with {node_access} table issues. http://drupal.org/node/197878 is fairly typical of this sort of problem.
Node Access is spooky stuff for most people, and there is generally no way to fix Node Access issues -- or bulk reset NA rules -- without writing SQL.
For the Domain Access suite, I wrote the Domain Content module, which does some of this. I also wrote the Devel Node Access Tester (for Drupal 6), which lets you assign dummy rules to your dummy nodes.
I'm thinking of a small modules that will let you:
- Review the contents of your {node_access} table.
- Batch update node access rules for your nodes.
- Report on which modules you use that set node access.
- Reset {node_access} to its default state.
Thoughts?

Comments
devel_node_access dupe
devel_node_access in devel package already does some of this. would be nice if you expanded that module ... not yet ported to D6 ... i'm not sure what batch update means. there is a rebuild button in the core admin UI if you have any node access modules installed.
batch
Right. I'll have to look more at what Devel already does, but I'm also thinking of a tool for non-developers.
In the Domain Content module, I provide an implementation of hook_node_operations() to allow batch setting of node access rules according to new rules set by a form element.
--
http://ken.therickards.com/
http://savannahnow.com/user/2
http://blufftontoday.com/user/3
--
http://ken.therickards.com/