接著昨天繼續學習openGauss,今天是第五天了。今天學習內容是使用一個用戶訪問多個數據庫。
老規矩，先登陸墨天輪為我準備的實訓實驗室

root@modb:~# su - omm
omm@modb:~$ gsql -r

創建表空間music_tbs、數據庫musicdb10 、用戶user10 并賦予 sysadmin權限

omm=# CREATE TABLESPACE music_tbs RELATIVE LOCATION 'tablespace/test_ts1';
CREATE TABLESPACE
omm=# CREATE DATABASE musicdb10 WITH TABLESPACE = music_tbs;
CREATE DATABASE
omm=#  CREATE USER user10 IDENTIFIED BY 'user10@1234';
NOTICE:  The encrypted password contains MD5 ciphertext, which is not secure.
CREATE ROLE
omm=# ALTER USER user10 SYSADMIN;
ALTER ROLE

以用戶user10 -的身份在數據庫postgres 中創建表products1，并插入一條數據

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 products1 (product_id int,product_name char(20),category char(30) );
CREATE TABLE
openGauss=> insert into products1  values(1502,'olympus camera','electrncs');
INSERT 0 1
openGauss=> select * from products1 ;product_id |     product_name     |            category            
------------+----------------------+--------------------------------1502 | olympus camera       | electrncs                     
(1 row)                     

以用戶user10 -的身份在數據庫omm 中創建表products1，并插入一條數據

openGauss=> \c omm user10
Password for user user10: 
Non-SSL connection (SSL connection is recommended when requiring high-security)
You are now connected to database "omm" as user "user10".
omm=> create table products1 (product_id int,product_name char(20),category char(30) );
CREATE TABLE
omm=> insert into products1  values(1502,'olympus camera','electrncs');
INSERT 0 1
omm=> select * from products1 ;product_id |     product_name     |            category            
------------+----------------------+--------------------------------1502 | olympus camera       | electrncs                     
(1 row)                     

以用戶user10 -的身份在數據庫musicdb10 中創建表products1，并插入一條數據

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 "musicdb10" as user "user10".
musicdb10=> 
musicdb10=> create table products1 (product_id int,product_name char(20),category char(30) );
CREATE TABLE
musicdb10=> insert into products1  values(1502,'olympus camera','electrncs');
INSERT 0 1
musicdb10=> select * from products1 ;product_id |     product_name     |            category            
------------+----------------------+--------------------------------1502 | olympus camera       | electrncs                     
(1 row)                     

總結

今天學習內容非常簡單，還是以創建用戶，創建數據庫，授予權限，建表，插入數據為主。多多練習。