openGauss每日一练第 5 天 | openGauss中一个用户可以访问多个数据库

1.创建数据库musicdb10，创建用户user10，赋予sysadmin权限

omm=# create database musicdb10;
CREATE DATABASE
omm=# create user user10 with sysadmin identified by 'abcd@123';
NOTICE:  The encrypted password contains MD5 ciphertext, which is not secure.
CREATE ROLE

2.用户user10访问数据库postgres，创建一个表并插入数据

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 products (
openGauss(> id integer,
openGauss(> name char(10)
openGauss(> );
CREATE TABLE
openGauss=> insert into products values (1, 'Books');
INSERT 0 1
openGauss=> select * from products ;
 id |    name    
----+------------
  1 | Books     
(1 row)

3.用户user10访问数据库omm，创建一个表并插入数据

openGauss=> \c omm
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 products (
omm(> id integer,
omm(> name char(10)
omm(> );
CREATE TABLE
omm=> insert into products values (1, 'Books');
INSERT 0 1
omm=> select * from products ;
 id |    name    
----+------------
  1 | Books     
(1 row)

4.用户user10访问数据库musicdb10，创建一个表并插入数据

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 products (
musicdb10(> id integer,
musicdb10(> name char(10)
musicdb10(>  );
CREATE TABLE
musicdb10=> insert into products values (1, 'Books');
INSERT 0 1
musicdb10=> select * from products ;
 id |    name    
----+------------
  1 | Books     
(1 row)