密保三权用户

PostgreSQL

//系统管理员
CREATE USER dsSys WITH PASSWORD '123456';
//安全管理员
CREATE USER dsSafe WITH PASSWORD '123456';
//审记管理员
CREATE USER dsAudit WITH PASSWORD '123456';

 

MariaDB

create user dsAudit@'%' identified by '123456';
mysql -uroot -pDsideaL147258369 -e "grant show databases,show view,select on *.* to 'dsAudit'@'%'"

create user dsSafe@'%' identified by '123456';
mysql -uroot -pDsideaL147258369 -e "grant create user on *.* to 'dsSafe'@'%'"

create user dsSys@'%' identified by '123456';
mysql -uroot -pDsideaL147258369 -e "grant create,drop,alter,select on *.* to 'dsSys'@'%'"