This plugin hasn’t been tested with the latest 3 major releases of WordPress. It may no longer be maintained or supported and may have compatibility issues when used with more recent versions of WordPress.

Shared User Table Roles

Description

When sharing the user and usermeta table between multiple wordpress
installations using the same database, any role given to the user is only valid
for a single wordpress installation.

This plugin ensures user roles, user capabilities and user settings are
shared between the multiple installations. This is configured using a wp-config
constant.

Any role set in any of the installations will be reflected in all other
installations.

Caveats:

  • Compatability with wordpress multisite is unknown

Installation

To set up multiple wordpress installations using the same database:

  1. Install all wordpress installations using the same database, but using a
    different $table_prefix in wp_config.

    For example two installations with β€œeng_” and β€œnld_”.

  2. Designate one wordpress installation as β€œprimary”. All other installations are
    secondary

    For example the installation with the prefix β€œeng_”.

  3. Install and activate this plugin on all secondary wordpress installations.

    In this example β€œnld_”.

  4. On all secondary wordpress installations configure CUSTOM_USER_TABLE and
    CUSTOM_USER_META_TABLE in wp-config to use the tables (users and usermeta)
    of the primary installation.

    See below for an example

  5. On all secondary wordpress installations, set SHARED_USER_TABLE_ROLES_PREFIX
    to be equal to the table prefix of the primary installation.

Primary

For example the relevant wp-config settings for the primary installation would
look like:

    $table_prefix  = 'eng_';

Secondary

For example the relevant wp-config settings for secondary installations would
look like:

    $table_prefix  = 'nld_';
    define('SHARED_USER_TABLE_ROLES_PREFIX', 'eng_');
    define('CUSTOM_USER_TABLE', 'eng_users');
    define('CUSTOM_USER_META_TABLE', 'eng_usermeta');

Reviews

❄️1️⃣ 9, 2018
Thanks for this great little plugin. Does exactly what it’s supposed to do. Works well with wordpress 4.9.1 … Keep it up! πŸ™‚
Read all 4 reviews

Contributors & Developers

“Shared User Table Roles” is open source software. The following people have contributed to this plugin.

Contributors

Changelog

1.0

  • initial release