openGauss每日一练第 4天

1.创建用户user1、user2、user3，授予user1、user2、user3数据库系统的SYSADMIN权限

create user user1 identified by 'zuoye@1234';create user user2 identified by 'zuoye@1234';
create user user3 identified by 'zuoye@1234';
alter user user1 sysadmin;
alter user user2 sysadmin;
alter user user3 sysadmin;

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

表名分别为： products1、 products2、 products3

向表中插入数据：

create database musicdb2 with tablespace =music_tbs1;

\c musicdb2 user1
create table products1 (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');

\c musicdb2 user2
create table products2 (product_id integer ,product_name char(20),category char(30));
insert into products2 values (1502,'olympus camera','electrncs'),(1601,'lamaze','toys'),(1700,'wait interface','Books'),(1666,'harry potter','toys');

\c musicdb2 user3
create table products3 (product_id integer ,product_name char(20),category char(30));
insert into products3 values (1502,'olympus camera','electrncs'),(1601,'lamaze','toys'),(1700,'wait interface','Books'),(1666,'harry potter','toys');

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

\c musicdb2 user1

\dt