1 Reply Latest reply on Nov 5, 2007 10:56 AM by Tom Cunningham

    Database-privileges

    Haagen Hasle Novice

      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

        • 1. Re: Database-privileges
          Tom Cunningham Master

          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.