X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=rt%2Fetc%2Facl.mysql;h=0ecaa3b15ce1522691c8197afd2aff75ef85ecc2;hb=781e1d52be20355e1e9d57102d6ae44a3f1cbeeb;hp=7feb376f54be521df8f45191ff6d25811b5a0c29;hpb=3ef62a0570055da710328937e7f65dbb2c027c62;p=freeside.git diff --git a/rt/etc/acl.mysql b/rt/etc/acl.mysql index 7feb376f5..0ecaa3b15 100755 --- a/rt/etc/acl.mysql +++ b/rt/etc/acl.mysql @@ -1,4 +1,8 @@ - -DELETE FROM user WHERE user like '!!DB_RT_USER!!'; -DELETE FROM db where db LIKE '!!DB_DATABASE!!'; -GRANT SELECT,INSERT,CREATE,INDEX,UPDATE,DELETE ON !!DB_DATABASE!!.* TO !!DB_RT_USER!!@!!DB_RT_HOST!! IDENTIFIED BY '!!DB_RT_PASS!!'; +sub acl { +return ( +"USE mysql;", +"DELETE FROM user WHERE user = '${RT::DatabaseUser}';", +"DELETE FROM db where db = '${RT::DatabaseName}';", +"GRANT SELECT,INSERT,CREATE,INDEX,UPDATE,DELETE ON ${RT::DatabaseName}.* TO ${RT::DatabaseUser}\@${RT::DatabaseRTHost} IDENTIFIED BY '${RT::DatabasePassword}';"); +} +1;