Creating the Streams Administrator
PROMPT (1) ** Creating tablespace strm_tbs
CREATE TABLESPACE strm_tbs DATAFILE
'/app/oracle/DNYTST10/data/strmtbs_01.dbf' SIZE 500M
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 4M
/
PROMPT (2) ** Creating User strmadm
CREATE USER strmadm IDENTIFIED BY strmadm
DEFAULT TABLESPACE strm_tbs QUOTA UNLIMITED
ON strm_tbs
/
PROMPT 3) ** Grant the privilege
GRANT CONNECT, RESOURCE, DBA TO strmadm
/
PROMPT 4) ** Use the AUTH package function
to grant privilege
BEGIN
DBMS_STREAMS_AUTH.GRANT_ADMIN_PRIVILEGE(
grantee => 'strmadm',
grant_privileges => true);
END;
/
SPOOL OFF
With the above code, the STRMADM user has
been created. By using the
dbms_streams_auth.grant_admin_privilege procedure, in a
single operation, all of the necessary privileges were granted
to the STRMADM user.
