创建数据库管理用户:
创建用户
dbadmin=> create user mingadmin;
CREATE USER
赋予role
dbadmin=> grant dbduser,dbadmin,pseudosuperuser to mingadmin;
GRANT ROLE
note
dbduser:运行非dba用户访问database designer使用命令行函数
dbadmin:创建删除用户,角色以及模式;查询系统表;结束用户进程;修改配置文件;但是不能启停数据库。
pseudosuperuser:可以认为几乎可以干所有的事,类似oracle的dba role。
enable role
dbadmin-> \c firstvdb mingadmin --\c db_name username
You are now connected to database "firstvdb" as user "mingadmin".
firstvdb=> set role dbduser,dbadmin,pseudosuperuser;
SET
验证
firstvdb=> show enabled roles;
name | setting
---------------+-----------------------------------
enabled roles | dbduser, dbadmin, pseudosuperuser
(1 row)
创建普通用户,语法跟oracle几乎一样:
create user ming1; --可以不指定密码。
grant test,dbduser to ming1;
create user ming2 identified by 'oracle'; --指定密码
grant test,dbduser to ming2;
alter user ming2 default role test; --指定默认 role
指定密码时要加单引号,区分大小写:
dbadmin=> create user ming3 identified by oracle;
ERROR 4856: Syntax error at or near "oracle" at character 33
LINE 1: create user ming3 identified by oracle;
^
dba
创建用户
dbadmin=> create user mingadmin;
CREATE USER
赋予role
dbadmin=> grant dbduser,dbadmin,pseudosuperuser to mingadmin;
GRANT ROLE
note
dbduser:运行非dba用户访问database designer使用命令行函数
dbadmin:创建删除用户,角色以及模式;查询系统表;结束用户进程;修改配置文件;但是不能启停数据库。
pseudosuperuser:可以认为几乎可以干所有的事,类似oracle的dba role。
enable role
dbadmin-> \c firstvdb mingadmin --\c db_name username
You are now connected to database "firstvdb" as user "mingadmin".
firstvdb=> set role dbduser,dbadmin,pseudosuperuser;
SET
验证
firstvdb=> show enabled roles;
name | setting
---------------+-----------------------------------
enabled roles | dbduser, dbadmin, pseudosuperuser
(1 row)
创建普通用户,语法跟oracle几乎一样:
create user ming1; --可以不指定密码。
grant test,dbduser to ming1;
create user ming2 identified by 'oracle'; --指定密码
grant test,dbduser to ming2;
alter user ming2 default role test; --指定默认 role
指定密码时要加单引号,区分大小写:
dbadmin=> create user ming3 identified by oracle;
ERROR 4856: Syntax error at or near "oracle" at character 33
LINE 1: create user ming3 identified by oracle;
^
dba