openGauss每日一练第5天

学习体系架构一个用户可以访问多个数据库

1.测试环境准备 创建数据库musicdb10，创建用户user10，赋予sysadmin权限

omm=# create tablespace music_tbs relative location 'tablespace/test_ts1';
CREATE TABLESPACE
omm=# create database musicdb1 with tablespace=music_tbs;
CREATE DATABASE
omm=# create database musicdb2 with tablespace=music_tbs;
CREATE DATABASE
omm=# create database musicdb3 with tablespace=music_tbs;
CREATE DATABASE

--- 创建数据库musicdb10，创建用户user10，赋予sysadmin权限
omm=# create user user10 identified by 'kunpeng@1234';
NOTICE:  The encrypted password contains MD5 ciphertext, which is not secure.
CREATE ROLE
omm=# alter user user10 sysadmin;
ALTER ROL
复制

2.用户user10访问数据库postgres，创建一个表并插入数据

omm=# \c postgres user10
Password for user user10: 
Non-SSL connection (SSL connection is recommended when requiring high-security)
You are now connected to database "postgres" as user "user10".
openGauss=> create table t11 (col1 char(20));
CREATE TABLE
openGauss=> insert into t11 values ('Hello openGauss! 11');
INSERT 0 1
postgres => select * from t11;
         col1         
----------------------
 Hello openGauss! 11 
复制

3.用户user10访问数据库omm，创建一个表并插入数据

omm=# \c omm user10
Password for user user10: 
Non-SSL connection (SSL connection is recommended when requiring high-security)
You are now connected to database "postgres" as user "user10".
omm=> create table t21 (col1 char(20));
CREATE TABLE
omm=>  insert into t21 values ('Hello openGauss! 21');
INSERT 0 1
omm => select * from t21;
         col1         
----------------------
 Hello openGauss! 21 
复制

4.用户user10访问数据库musicdb10，创建一个表并插入数据

omm=# \c musicdb10 user10
Password for user user10: 
Non-SSL connection (SSL connection is recommended when requiring high-security)
You are now connected to database "postgres" as user "user10".
musicdb10=> create table t31 (col1 char(20));
CREATE TABLE
musicdb10=>  insert into t31 values ('Hello openGauss! 31');
INSERT 0 1
musicdb10 => select * from t31;
         col1         
----------------------
 Hello openGauss! 31 
复制