openGauss每日一练第4天 | 使用多个用户访问同一个数据库

课后作业
1.创建用户user1、user2、user3，授予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';

--授予user1、user2、user3数据库系统的SYSADMIN权限：

ALTER USER user1 SYSADMIN;
ALTER USER user2 SYSADMIN;
ALTER USER user3 SYSADMIN;

查看用户

\du

2.分别使用user1、user2、user3访问数据库musicdb2，创建各自的表，并插入数据。表名和数据如下：

表名分别为： products1、 products2、 products3

CREATE DATABASE musicdb2  WITH TABLESPACE = music_tbs;
\c musicdb2 user1
create table products1 (product_id INTEGER, product_name Char(20), category 	Char(30));
\c musicdb2 user2
create table products2 (product_id INTEGER, product_name Char(20), category 	Char(30));
\c musicdb2 user3
create table products3 (product_id INTEGER, product_name Char(20), category 	Char(30));

insert into products1 values (1502, 'olympus camera', 'electrncs' ), (1601, 'lamaze', 'toys' ), (1700, 'wait interface', 'Books' ), (1666,  'harry potter', 'toys' );

insert into products2 values (1502, 'olympus camera', 'electrncs' ), (1601, 'lamaze', 'toys' ), (1700, 'wait interface', 'Books' ), (1666,  'harry potter', 'toys' );

insert into products3 values (1502, 'olympus camera', 'electrncs' ), (1601, 'lamaze', 'toys' ), (1700, 'wait interface', 'Books' ), (1666,  'harry potter', 'toys' );

3.使用user1、user2、user3用户中的任何一个，查看当前数据库musicdb2有哪些表

\dt