set echo on

alter session set container=pdb01;

grant connect,resource,dba to ggs identified by ggs;

grant connect,resource,dba to gge identified by gge;

grant connect,resource,dba to ggr identified by ggr;

grant CREATE SESSION,ALTER SESSION,ALTER SYSTEM,SELECT ANY DICTIONARY,FLASHBACK ANY TABLE,SELECT ANY TABLE,SELECT ANY TRANSACTION to gge;

grant SELECT on dba_clusters to gge;

grant EXECUTE on DBMS_FLASHBACK to gge;

grant CREATE TABLE,LOCK ANY TABLE to ggr;

alter user gge default tablespace users;

alter user gge default tablespace users;

alter user ggs default tablespace ggs_data;

set echo off

--  ggs user

@@sequence

@@marker_setup.sql

@@ddl_setup.sql

@@role_setup.sql

@@ddl_enable.sql

set echo on

GRANT GGS_GGSUSER_ROLE TO ggs;

GRANT GGS_GGSUSER_ROLE TO gge;

alter user gge default role all;

alter user gge default role all;

alter user ggs default role all;

exit