XStream管理者の設定

CREATE TABLESPACE xstream_tbs DATAFILE '$ORACLE_HOME/dbs/xstream_tbs.dbf' SIZE 25M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;

CREATE USER username IDENTIFIED BY password
DEFAULT TABLESPACE xstream_tbs
QUOTA UNLIMITED ON xstream_tbs;

GRANT DBA TO username;
GRANT CONNECT, CREATE TABLE TO username;
GRANT RESOURCE TO username;
GRANT CREATE TABLESPACE TO username;
GRANT UNLIMITED TABLESPACE TO username;
GRANT SELECT_CATALOG_ROLE TO username;
GRANT EXECUTE_CATALOG_ROLE TO username;
GRANT CREATE SEQUENCE TO username;
GRANT CREATE SESSION TO username;
GRANT CREATE ANY VIEW TO username;
GRANT CREATE ANY TABLE TO username;
GRANT SELECT ANY TABLE TO username;
GRANT COMMENT ANY TABLE TO username;
GRANT LOCK ANY TABLE TO username;
GRANT SELECT ANY DICTIONARY TO username;
GRANT EXECUTE ON SYS.DBMS_CDC_PUBLISH to username;
GRANT CREATE ANY TRIGGER TO username;
GRANT ALTER ANY TRIGGER TO username;
GRANT DROP ANY TRIGGER TO username;

BEGIN
   DBMS_XSTREAM_AUTH.GRANT_ADMIN_PRIVILEGE(
      grantee => 'username',
      privilege_type => 'CAPTURE',
      grant_select_privileges => TRUE);
END;
/

BEGIN
   DBMS_XSTREAM_AUTH.GRANT_ADMIN_PRIVILEGE(
      grantee => 'username',
      privilege_type => 'APPLY',
      grant_select_privileges => TRUE);
END;
/