1 创建用户

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

[omm@node1 ~]$ gsql -d postgres -p 26000
gsql ((openGauss 3.1.0 build 4e931f9a) compiled at 2022-09-29 14:19:24 commit 0 last mr  )
Non-SSL connection (SSL connection is recommended when requiring high-security)
Type "help" for help.

openGauss=# \db
           List of tablespaces
    Name    | Owner |      Location
------------+-------+---------------------
 music_tbs  | omm   | tablespace/test_ts1
 pg_default | omm   |
 pg_global  | omm   |
(3 rows)

openGauss=# \l
                             List of databases
   Name    | Owner | Encoding |  Collate   |   Ctype    | Access privileges
-----------+-------+----------+------------+------------+-------------------
 musicdb   | omm   | UTF8     | zh_CN.utf8 | zh_CN.utf8 |
 musicdb1  | omm   | UTF8     | zh_CN.utf8 | zh_CN.utf8 |
 musicdb2  | omm   | UTF8     | zh_CN.utf8 | zh_CN.utf8 |
 musicdb3  | omm   | UTF8     | zh_CN.utf8 | zh_CN.utf8 |
 postgres  | omm   | UTF8     | zh_CN.utf8 | zh_CN.utf8 |
 template0 | omm   | UTF8     | zh_CN.utf8 | zh_CN.utf8 | =c/omm           +
           |       |          |            |            | omm=CTc/omm
 template1 | omm   | UTF8     | zh_CN.utf8 | zh_CN.utf8 | =c/omm           +
           |       |          |            |            | omm=CTc/omm
 zyfdb     | omm   | UTF8     | zh_CN.utf8 | zh_CN.utf8 |
(8 rows)

openGauss=# \c musicdb2
Non-SSL connection (SSL connection is recommended when requiring high-security)
You are now connected to database "musicdb2" as user "omm".
musicdb2=#
musicdb2=# CREATE USER user1 IDENTIFIED BY 'kunpeng@1234';
 CREATE USER user2 IDENTIFIED BY 'kunpeng@1234';
 CREATE USER user3 IDENTIFIED BY 'kunpeng@1234';
 CREATE ROLE

musicdb2=# 
ALTER USER user1 SYSADMIN;
ALTER USER user2 SYSADMIN;
ALTER USER user3 SYSADMIN

musicdb2=#

musicdb2=# \du
                                                              List of roles
 Role name |                                                    Attributes                                                    | Member of
-----------+------------------------------------------------------------------------------------------------------------------+-----------
 omm       | Sysadmin, Create role, Create DB, Replication, Administer audit, Monitoradmin, Operatoradmin, Policyadmin, UseFT | {}
 user1     | Sysadmin                                                                                                         | {}
 user2     | Sysadmin                                                                                                         | {}
 user3     | Sysadmin                                                                                                         | {}
 zyf       | Sysadmin                                                                                                         | {}

2 三个用户各创建表

2.1 user1

musicdb2=# \c musicdb2 user1
Password for user user1:
Non-SSL connection (SSL connection is recommended when requiring high-security)
You are now connected to database "musicdb2" as user "user1".
musicdb2=> create table products1 (
	product_id int,
	product_name char(20),
	category  char(20)
	);

CREATE TABLE
musicdb2=>
musicdb2=> dt
musicdb2-> \dt
                           List of relations
 Schema |   Name    | Type  | Owner |             Storage
--------+-----------+-------+-------+----------------------------------
 user1  | products1 | table | user1 | {orientation=row,compression=no}
(1 row)

2.2 user2

musicdb2-> \c musicdb2 user2
Password for user user2:
Non-SSL connection (SSL connection is recommended when requiring high-security)
You are now connected to database "musicdb2" as user "user2".
musicdb2->
musicdb2->

musicdb2=>
musicdb2=> create table products2 (
product_id int,
product_name char(20),
category  char(20)
);

insert into products2 values(2,'p2','user2');
	musicdb2(> musicdb2(> musicdb2(> musicdb2(> CREATE TABLE
musicdb2=> musicdb2=> INSERT 0 1
musicdb2=>
musicdb2=>
musicdb2=> select *from products2;
 product_id |     product_name     |       category
------------+----------------------+----------------------
          2 | p2                   | user2
(1 row)

musicdb2=> \dt
                           List of relations
 Schema |   Name    | Type  | Owner |             Storage
--------+-----------+-------+-------+----------------------------------
 user2  | products2 | table | user2 | {orientation=row,compression=no}
(1 row)

2.3 user3

musicdb2-> \conninfo
You are connected to database "musicdb2" as user "user3" via socket in "/opt/huawei/tmp" at port "26000".
musicdb2->

usicdb2=>
create table products3 (
product_id int,
product_name char(20),
category  char(20)
);musicdb2=> musicdb2(> musicdb2(> musicdb2(> musicdb2(>
CREATE TABLE
musicdb2=> insert into products3 values(3,'p3','user3');

INSERT 0 1
musicdb2=> musicdb2=>
musicdb2=> select * from products3;
 product_id |     product_name     |       category
------------+----------------------+----------------------
          3 | p3                   | user3
(1 row)

musicdb2=>

3 查看当前数据库musicdb2有哪些表

[omm@node1 ~]$ gsql -d musicdb2 -p 26000 -U user1  -r
Password for user user1:
gsql ((openGauss 3.1.0 build 4e931f9a) compiled at 2022-09-29 14:19:24 commit 0 last mr  )
Non-SSL connection (SSL connection is recommended when requiring high-security)
Type "help" for help.

musicdb2=> \dt
                           List of relations
 Schema |   Name    | Type  | Owner |             Storage
--------+-----------+-------+-------+----------------------------------
 user1  | products1 | table | user1 | {orientation=row,compression=no}
(1 row)

4 如何查出 musicdb2 数据库所有的表？

还不会