[Forum] Database Permission

[henrybui]

The username that we use to connect to forum database haven't been granted all the permissions on that database (only read/write/update). Permission of CREATE table, DROP table are not granted.

May I know what should be the setting in this case? Full permissions for that username on forum database?

[JamesAB]

The install or upgrade scripts may fail if you have not granted full permissions to your database username.

[henrybui]

Thanks JamesAB,

We are able to install / upgrade the forum without any problems.

However, right now there're number of temp tables inside the database. We suspect that cron job (or vbulletin core) created these tables but have no permission to drop them?

Please help,
Thanks