Permissions to MySQL database

Discussion in 'Spigot Plugin Help' started by Itaquito, Jul 17, 2020.

  1. Hello!

    Which perms should I give a normal plugin to the database? so I can keep the maximum security on it.


    Thanks.
     
  2. NewEraStudios

    NewEraStudios Previously VenomApps

    You can create a MySQL user specific for that plugin, with the plugin names for example, and give that user access only to his database, letting it execute SELECT, INSERT and UPDATE i guess it will be okay.
     
  3. Oh.. Will the plugins be able to create/modify tables with those 3 perms?
     
  4. NewEraStudios

    NewEraStudios Previously VenomApps

    Well it should yes. If you see that it can't, just add the missing permissions to that user and fixed.
     
  5. Oh, that's for sure a way for seeing which perms requires which plugin.
     
  6. NewEraStudios

    NewEraStudios Previously VenomApps

    You can ask the developer of that plugin and he will happily answer you with what SQL queries he does.
     
  7. Strahan

    Benefactor

    Negative. You need CREATE and ALTER as well if he wants to create or modify tables.
     
    • Agree Agree x 1
  8. Fun fact: Luckperms needs INDEX and DELETE. AdvancedBans also needs DELETE
     
    • Funny Funny x 1