openGauss每日一练第5天

今天实验内容，创建用户并赋予权限，在不同的数据库下使用此用户创建表。

1.登录opengauss数据库，使用gsql -r登录

root@modb:~# su - omm
omm@modb:~$ gsql -r
gsql ((openGauss 3.0.0 build 02c14696) compiled at 2022-04-01 18:12:00 commit 0 last mr  )
Non-SSL connection (SSL connection is recommended when requiring high-security)
Type "help" for help.

2.创建表空间tbs1及。使用create tablespace命令。并在表空间下创建数据库musicdb10.

omm=# create tablespace tbs1 relative location 'tablespace/tbs1';
CREATE TABLESPACE
omm=# create database musicdb10 with tablespace tbs1;
CREATE DATABASE

3.创建用户user10，并给与sysadmin权限。

omm=# create user user10 identified by 'Dongyunyun1!';
NOTICE:  The encrypted password contains MD5 ciphertext, which is not secure.
CREATE ROLE
omm=# alter user user10 sysadmin;
ALTER ROLE

4.用user10分别连接postgres数据库、omm数据库、musicdb10数据库，并创建相应的表

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 t(dbname varchar(100));
openGauss=> CREATE TABLE
insert into t values('postgres');
openGauss=> INSERT 0 1
select *from t;
  dbname  
----------
 postgres
(1 row)

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 tomm(dbname varchar(100));
CREATE TABLE
omm=> insert into tomm values('omm');
INSERT 0 1
omm=> select *from tomm;
 dbname 
--------
 omm
(1 row)

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=> create table t(dbname varchar(100));
CREATE TABLE
musicdb10=> insert into t values('musicdb10');
INSERT 0 1
musicdb10=> select *from t;
  dbname   
-----------
 musicdb10
(1 row)