Database-privileges

[haagenhasle]

Does anyone have a description of the privileges the database-user JBossESB logs inn as must have? I'm planning to use the same user for every datasource (jbpm-ds.xml, juddi-ds.xml, message-store-ds.xml, mysql-ds.xml).

Regards, Haagen

[tcunning]

You probably need all of the non-administrative privileges (CREATE, DROP, INSERT, UPDATE, DELETE, SELECT, INDEX, ALTER) but can omit the ones that deal with creating new users, stored routines, or server administration. Some of the scripts do create and drop tables on the first startup, so you'll definitely need CREATE and DROP.

If you are worried about security, I'd definitely create database(s) solely for these and use a user that only has permission for that database.