create_prouser_privlages.sql
上传用户:xiao730204
上传日期:2007-01-04
资源大小:141k
文件大小:3k
源码类别:
WEB邮件程序
开发平台:
PHP
- DELETE FROM db WHERE user = 'prouser';
- INSERT INTO db (
- host, db, user,
- Select_priv, Insert_priv, Update_priv, Delete_priv,
- Create_priv, Drop_priv )
- VALUES (
- 'localhost', 'prometheus_users', 'prouser',
- 'Y', 'Y', 'Y', 'Y',
- 'Y', 'Y'
- );
- INSERT INTO db (
- host, db, user,
- Select_priv, Insert_priv, Update_priv, Delete_priv,
- Create_priv, Drop_priv )
- VALUES (
- 'localhost', 'prometheus_domains', 'prouser',
- 'Y', 'Y', 'Y', 'Y',
- 'Y', 'Y'
- );
- INSERT INTO db (
- host, db, user,
- Select_priv, Insert_priv, Update_priv, Delete_priv,
- Create_priv, Drop_priv )
- VALUES (
- 'localhost', 'prometheus_privileges', 'prouser',
- 'Y', 'Y', 'Y', 'Y',
- 'Y', 'Y'
- );
- INSERT INTO db (
- host, db, user,
- Select_priv, Insert_priv, Update_priv, Delete_priv,
- Create_priv, Drop_priv )
- VALUES (
- 'localhost', 'prometheus_sessions', 'prouser',
- 'Y', 'Y', 'Y', 'Y',
- 'Y', 'Y'
- );
- INSERT INTO db (
- host, db, user,
- Select_priv, Insert_priv, Update_priv, Delete_priv,
- Create_priv, Drop_priv )
- VALUES (
- 'localhost', 'prometheus_settings', 'prouser',
- 'Y', 'Y', 'Y', 'Y',
- 'Y', 'Y'
- );
- INSERT INTO db (
- host, db, user,
- Select_priv, Insert_priv, Update_priv, Delete_priv,
- Create_priv, Drop_priv )
- VALUES (
- 'localhost', 'mail_settings', 'prouser',
- 'Y', 'Y', 'Y', 'Y',
- 'Y', 'Y'
- );
- INSERT INTO db (
- host, db, user,
- Select_priv, Insert_priv, Update_priv, Delete_priv,
- Create_priv, Drop_priv )
- VALUES (
- 'localhost', 'prometheus_customers', 'prouser',
- 'Y', 'Y', 'Y', 'Y',
- 'Y', 'Y'
- );
- INSERT INTO db (
- host, db, user,
- Select_priv, Insert_priv, Update_priv, Delete_priv,
- Create_priv, Drop_priv )
- VALUES (
- 'localhost', 'bind', 'prouser',
- 'Y', 'Y', 'Y', 'Y',
- 'Y', 'Y'
- );