ps4player Posted February 3, 2020 Share Posted February 3, 2020 Hi, As we have (here) and (here) we need this Privileges for using/updating: For day to day use, only the following database privileges are required. All others may be disabled. DELETE INSERT SELECT UPDATE LOCK TABLES Please note that installation, upgrading, activating, and deactivating modules require the following additional privileges. ALTER CREATE DROP INDEX So what about this Privileges ? Grant Reference Create tmp tables Lock Tables Show View Create Routine Alter Routine Execute Create View Event Trigger 0 Quote Link to comment Share on other sites More sharing options...
Kian Posted February 3, 2020 Share Posted February 3, 2020 56 minutes ago, ps4player said: So what about this Privileges ? Grant Reference Create tmp tables Lock Tables Show View Create Routine Alter Routine Execute Create View Event Trigger As far as I know WHMCS doesn't use them. Anyway personally I suggest you to grant all privileges since third-party modules make an extensive use of DROP, CREATE and ALERT. 0 Quote Link to comment Share on other sites More sharing options...
twhiting9275 Posted February 4, 2020 Share Posted February 4, 2020 22 hours ago, Kian said: As far as I know WHMCS doesn't use them. Anyway personally I suggest you to grant all privileges since third-party modules make an extensive use of DROP, CREATE and ALERT. This would be correct. Truth be told (and this, of course, is just my opinion), I don't see leaving those privs in being an option. Triggers? Maybe, but that can be disabled server wide, at least last time I checked it could? 0 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.