Title: select * from user
Last modified: March 2, 2020

---

# select * from user

 *  Resolved [gassi](https://wordpress.org/support/users/gassi/)
 * (@gassi)
 * [6 years, 3 months ago](https://wordpress.org/support/topic/select-from-user/)
 * 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](https://wordpress.org/support/users/gassi/)
 * (@gassi)
 * [6 years, 3 months ago](https://wordpress.org/support/topic/select-from-user/#post-12502634)
 * I will use a View because this solves an other problem I have (nothing to do 
   with external login)
 *  Plugin Author [tbenyon](https://wordpress.org/support/users/tbenyon/)
 * (@tbenyon)
 * [6 years, 3 months ago](https://wordpress.org/support/topic/select-from-user/#post-12508818)
 * Hey [@gassi](https://wordpress.org/support/users/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.

 * ![](https://s.w.org/plugins/geopattern-icon/external-login_fbebd6.svg)
 * [External Login](https://wordpress.org/plugins/external-login/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/external-login/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/external-login/)
 * [Active Topics](https://wordpress.org/support/plugin/external-login/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/external-login/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/external-login/reviews/)

 * 2 replies
 * 2 participants
 * Last reply from: [tbenyon](https://wordpress.org/support/users/tbenyon/)
 * Last activity: [6 years, 3 months ago](https://wordpress.org/support/topic/select-from-user/#post-12508818)
 * Status: resolved