-- new table to hold authorizationDefinitions USE sts_audconf; DROP TABLE IF EXISTS authorizationDefinitions; CREATE TABLE authorizationDefinitions ( role VARCHAR(4) NOT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8; GRANT ALL ON sts_audconf.authorizationDefinitions TO 'sts'@'%';