| General Information |
| Purpose |
Manage privileges needed for streams administration |
| Source |
{ORACLE_HOME}/rdbms/admin/dbmsstr.sql |
| Dependencies |
| DBMS_APPLY_ADM |
DBMS_REPCAT_COMMON_UTL |
PLITBLM |
| DBMS_ASSERT |
DBMS_REPCAT_DECL |
UTL_FILE |
| DBMS_LOGREP_UTIL |
DBMS_STREAMS_ADM_UTL |
|
|
| Security Model |
Execute is granted to the
EXECUTE_CATALOG_ROLE role |
| |
| GRANT_ADMIN_PRIVILEGE |
|
Grants the privileges needed by a user to be an administrator for streams |
dbms_streams_auth.grant_admin_privilege(
grantee IN VARCHAR2,
grant_privileges IN BOOLEAN DEFAULT TRUE,
file_name IN VARCHAR2 DEFAULT NULL,
directory_name IN VARCHAR2 DEFAULT NULL); |
| See CDC Demo 2 |
| |
| GRANT_REMOTE_ADMIN_ACCESS |
|
Grants the privileges to perform remote Streams
administration through a database link |
dbms_streams_auth.grant_remote_admin_access(grantee IN VARCHAR2); |
| See Streams Demo 1 |
| |
| REVOKE_ADMIN_PRIVILEGE |
| Revokes the streams
administration privileges. Optionally generates a script whose execution has the same effect |
dbms_streams_auth.revoke_admin_privilege(
grantee IN VARCHAR2,
revoke_privileges IN BOOLEAN DEFAULT TRUE,
file_name IN VARCHAR2 DEFAULT NULL,
directory_name IN VARCHAR2 DEFAULT NULL); |
| See CDC Demo 2 |
| |
| REVOKE_REMOTE_ADMIN_ACCESS |
|
Revokes the privileges to perform remote Streams
administration through a database link |
dbms_streams_auth.revoke_remote_admin_access(grantee IN VARCHAR2); |
| See Streams Demo 1 |
