学习openGauss体系结构，使用多个用户访问同一个数据库
创建测试数据
#su -omm
$ gsql -r
drop DATABASE IF EXISTS musicdb;
drop DATABASE IF EXISTS musicdb1;
drop DATABASE IF EXISTS musicdb2;
drop DATABASE IF EXISTS musicdb3;
drop tablespace IF EXISTS music_tbs;
CREATE TABLESPACE music_tbs RELATIVE LOCATION ‘tablespace/test_ts1’;
CREATE DATABASE musicdb WITH TABLESPACE = music_tbs;
创建用户user1、user2、user3并授予SYSADMIN权限
CREATE USER user1 IDENTIFIED BY ‘kunpeng@1234’;
CREATE USER user2 IDENTIFIED BY ‘kunpeng@1234’;
CREATE USER user3 IDENTIFIED BY ‘kunpeng@1234’;
ALTER USER user1 SYSADMIN;
ALTER USER user2 SYSADMIN;
ALTER USER user3 SYSADMIN;
查看已创建的用户
分别使用user1、user2、user3用户访问数据库musicdb
1）user1登录并进行DDL、DML操作
omm=# \c musicdb user1
create table products1(product_id INTEGER,product_name char(20),category char(20));
insert into products1 values
(1502,‘olympus camera’,‘electrncs’),
(1601,‘lamaze’,‘toys’),
(1700,‘wait interface’,‘Books’),
(1666,‘harry potter’,‘toys’);
select * from products1;
2）user2登录并进行DDL、DML操作
omm=# \c musicdb user2
create table products2(product_id INTEGER,product_name char(20),category char(20));
insert into products2 values
(1502,‘olympus camera’,‘electrncs’),
(1601,‘lamaze’,‘toys’),
(1700,‘wait interface’,‘Books’),
(1666,‘harry potter’,‘toys’);
select * from products2;
3）user3登录并进行DDL、DML操作
omm=# \c musicdb user3
create table products3(product_id INTEGER,product_name char(20),category char(20));
insert into products3 values
(1502,‘olympus camera’,‘electrncs’),
(1601,‘lamaze’,‘toys’),
(1700,‘wait interface’,‘Books’),
(1666,‘harry potter’,‘toys’);
select * from products3;
创建后查看已创建的表
musicdb=> \dt
