nodeaccess vs. node_access

We encourage users to post events happening in the community to the community events group on https://www.drupal.org.
ranoble's picture

What is the difference between the table nodeaccess and the table node_access? Do I need both of them?

Comments

In my Drupal 6 sites, there

Sheldon Rampton's picture

In my Drupal 6 sites, there is a node_access table but no nodeaccess table. The node_access table is created by Drupal core, so you shouldn't delete it. I'm guessing that the nodeaccess table was probably created by the "nodeaccess" module, which is a third-party module:

http://drupal.org/project/nodeaccess

Just to make things a little more confusing, you should be aware that there is also a third-party "node_access" module which is different than the third-party "nodeaccess" module:

http://drupal.org/project/node_access

However, the node_access TABLE is NOT created by the node_access module. It's created by Drupal core, so don't delete it.

If you have the nodeaccess module installed on your site, you shouldn't delete the nodeaccess table either. However, uninstalling the module should delete the table for you.

Sheldon Rampton
Senior web developer, New York State Senate
http://www.nysenate.gov
http://drupal.org/user/13085

Wisconsin

Group organizers

Group notifications

This group offers an RSS feed. Or subscribe to these personalized, sitewide feeds: