数据库作业2

[ omm@ecs-4345 ~]$ gsql -d postgres -p 26000

gsql ((openGauss 2.0.0 build 78689da9) compiled at 2021-03-31 21:03:52 commit 0last mr)

Non-SSL connection (SSL connection is recommended when requiring high-security)

Type "help" for help.

postgres=# create user zhudongqi password 'Bigdata@123' ;CREATE ROLE

postgres=# grant all privileges to zhudongqi ;ALTER ROLE

postgres=#

postgres=#revoke all privilege from wangshenghao;ALTER ROLE

postgres=# create schemaCREATE SCHEMA

postgres=# create table tpcds.reason(postgres(#r_reason_skinteger not null,postgres(# r_reason_idchar( 16)not null,postgres (# r_reason_desc

varchar (20)

postgres(#);

CREATE TABLE

postgres=# grant usage on schema tpcds to wangshenghaopostgres-# ;

GRANT

postgres=# grant all privileges on tpcds.reason to wangshenghao;ERROR:role "wangsgo" does