select * from user

  • Resolved gassi

    (@gassi)


    5 years ago

    Hi!

    for the plugin I created a extra DB user that has only rights to some columns of the user table, because some other columns have very sensitive Information….

    the problem is that the wordpress Plugin select: select * from user;
    so there is a Problem:

    WordPress-Datenbank-Fehler: [SELECT command denied to user ‘external_login’@’localhost’ for table ‘user’]
    SELECT * FROM user LIMIT 5

    And I receive a Error: 500

    Is there a way that the plugin only select the needed columns or do I have to create a view in the Database?

    thx+br Gassi

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter gassi

    (@gassi)

    I will use a View because this solves an other problem I have (nothing to do with external login)

    Plugin Author tbenyon

    (@tbenyon)

    Hey @gassi,

    Apologies for the delay in getting back to you.

    Sounds like you’ve solved your problem – awesome ??

    Thanks,

    Tom

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘select * from user’ is closed to new replies.