Use members plugin to limit access to WP Data Access plugin functionality

  • Resolved Tobias Eigen

    (@tobiaseigen)


    6 years, 1 month ago

    Greetings!

    I am pleased to encounter this plugin. Kudos on the great work! My use case is that I’d like to allow some staff access to only one table in the wordpress mysql database, to add, update, delete and bulk import data. This plugin allows that but so much (too much!) more. Unfortunately my hosting provider (wpengine) only provides one mysql user with full access as required to host a wordpress site.

    Your plugin gets me pretty far towards my goal. I see you provide some roles functionality, but you also warn not to enable it alongside another permissions plugin. I use the members plugin (https://ww.wp.xz.cn/plugins/members/) and have extended it quite a bit already to limit access to certain capabilities by role.

    Do you have any advice for an approach to limiting access to your plugin’s functionality, to lock down everything except the DATA EXPLORER tab, excluding all tables except the ones I want staff to be able to access?

    Thanks!

Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    6 years, 1 month ago

    Hi Tobias,

    Let me first check if I understand your use case correctly:
    (1) You staff has access to the WordPress dashboard.
    (2) You want to give them access to a specific table.
    (3) Your staff does not have admin access.

    The WP Data Access dashboard menu is only available to admin users. Without admin access your users will not be able to access the Data Explorer. Please don’t change the plugin code the lower the menu permissions! That would be the simplest way to solve this issue, but would result in an insecure installation.

    If you have some PHP programming skills: checkout the link below to see how you can add a table to a user menu:
    https://wpdataaccess.com/2020/04/08/how-to-use-wp-data-access-classes-in-your-own-php-code/

    If you have no programming skills: do your users have access to a menu slug? It is very simple to add a table to an existing menu, but the menu must be available through a menu slug. You’ll find a explanation here:
    https://wpdataaccess.com/docs/documentation/data-explorer/table-settings/#dashboard-menus

    If none of these options works for you, just give me a few days. I have an idea for a generic solution that could help others we well…

    Best regards,
    Peter

    Thread Starter Tobias Eigen

    (@tobiaseigen)

    6 years, 1 month ago

    Thanks, Peter! You’ve got it all right. Let me look into this and discuss with the programmer I work with and we’ll see if this gets us all the way there.

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    6 years, 1 month ago

    Hi Tobias,

    Just wanted to let you know I got the same question today from another user. I’ll add a feature to allow plugin users to give non admin users access to tables without programming. Hope to finish it this week. I’ll let you know when it is available.

    Best regards,
    Peter

    Thread Starter Tobias Eigen

    (@tobiaseigen)

    6 years, 1 month ago

    sweet! thanks, peter!

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    6 years, 1 month ago

    Hi Tobias,

    Just wanted to let you know that a new version was released which supports CSV file import. We’ll discuss further details in private.

    Best regards,
    Peter

    larryhines

    (@larryhines)

    6 years, 1 month ago

    Really glad to see the new CSV file import feature. Unfortunately, I get an error when I tried to use it. I tried with both Google sheets and Excel files saved in CSV format. Is there any instructions yet?

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    6 years, 1 month ago

    Yes! Sorry, there is an error im the CSV import. I forgot to add the create table script to the repository update! 🙈 I will have to upload a new version, hopefully tomorrow…

    You can find an instruction video here:
    https://wpdataaccess.com/docs/documentation/data-explorer/import-csv-file/

    If you are using Google Merchant product feeds (or anybody reading this), I’m interested to doing doing some research together to find a way to load these feeds into a database table and publish it with the Data Publisher.

    Best regards,
    Peter

Viewing 7 replies - 1 through 7 (of 7 total)

The topic ‘Use members plugin to limit access to WP Data Access plugin functionality’ is closed to new replies.