walkerdba
asked on
oracle streams
All there were created
what is next to created oracle streams
BEGIN
DBMS_STREAMS_AUTH.GRANT_AD MIN_PRIVIL EGE(
grantee => 'strmadmin',
grant_privileges => FALSE,
file_name => 'grant_strms_privs.sql',
directory_name => 'admin_dir');
END;
/
-- rule privileges section
grant execute on dbms_rule_adm to "STRMADMIN"
/
BEGIN
dbms_rule_adm.grant_system _privilege (
privilege => dbms_rule_adm.CREATE_EVALU ATION_CONT EXT_OBJ,
grantee => '"STRMADMIN"',
grant_option => true);
END;
/
BEGIN
dbms_rule_adm.grant_system _privilege (
privilege => dbms_rule_adm.CREATE_RULE_ SET_OBJ,
grantee => '"STRMADMIN"',
grant_option => true);
END;
/
BEGIN
dbms_rule_adm.grant_system _privilege (
privilege => dbms_rule_adm.CREATE_RULE_ OBJ,
grantee => '"STRMADMIN"',
grant_option => true);
END;
/
BEGIN
dbms_rule_adm.grant_system _privilege (
privilege => dbms_rule_adm.CREATE_ANY_R ULE_SET,
grantee => '"STRMADMIN"',
grant_option => true);
END;
/
BEGIN
dbms_rule_adm.grant_system _privilege (
privilege => dbms_rule_adm.ALTER_ANY_RU LE_SET,
grantee => '"STRMADMIN"',
grant_option => true);
END;
/
BEGIN
dbms_rule_adm.grant_system _privilege (
privilege => dbms_rule_adm.EXECUTE_ANY_ RULE_SET,
grantee => '"STRMADMIN"',
grant_option => true);
END;
/
BEGIN
dbms_rule_adm.grant_system _privilege (
privilege => dbms_rule_adm.CREATE_ANY_R ULE,
grantee => '"STRMADMIN"',
grant_option => true);
END;
/
BEGIN
dbms_rule_adm.grant_system _privilege (
privilege => dbms_rule_adm.ALTER_ANY_RU LE,
grantee => '"STRMADMIN"',
grant_option => true);
END;
/
BEGIN
dbms_rule_adm.grant_system _privilege (
privilege => dbms_rule_adm.EXECUTE_ANY_ RULE,
grantee => '"STRMADMIN"',
grant_option => true);
END;
/
-- queue privileges section
grant execute on dbms_aq to "STRMADMIN"
/
grant execute on dbms_aqadm to "STRMADMIN"
/
BEGIN
dbms_aqadm.grant_system_pr ivilege(
'ENQUEUE_ANY',
'"STRMADMIN"',
admin_option => TRUE);
END;
/
BEGIN
dbms_aqadm.grant_system_pr ivilege(
'DEQUEUE_ANY',
'"STRMADMIN"',
admin_option => TRUE);
END;
/
BEGIN
dbms_aqadm.grant_system_pr ivilege(
'MANAGE_ANY',
'"STRMADMIN"',
TRUE);
END;
/
grant select on dba_queue_tables to "STRMADMIN"
/
grant select on dba_queues to "STRMADMIN"
/
grant select on dba_queue_schedules to "STRMADMIN"
/
grant select on sys.v_$aq to "STRMADMIN"
/
grant select on sys.gv_$aq to "STRMADMIN"
/
grant select on sys.aq$_propagation_status to "STRMADMIN"
/
grant execute on sys.dbms_aqin to "STRMADMIN"
/
grant select on sys.aq$internet_users to "STRMADMIN"
/
grant execute on sys.dbms_transform to "STRMADMIN"
/
grant execute on sys.dbms_aqelm to "STRMADMIN"
/
grant select on dba_aq_agents to "STRMADMIN"
/
grant select on dba_aq_agent_privs to "STRMADMIN"
/
grant select on dba_queue_subscribers to "STRMADMIN"
/
-- streams packages section
grant execute on dbms_capture_adm to "STRMADMIN"
/
grant execute on dbms_propagation_adm to "STRMADMIN"
/
grant execute on dbms_apply_adm to "STRMADMIN"
/
grant execute on dbms_streams_adm to "STRMADMIN"
/
grant execute on dbms_streams_messaging to "STRMADMIN"
/
grant execute on dbms_streams_advisor_adm to "STRMADMIN"
/
grant execute on dbms_capture_switch_adm to "STRMADMIN"
/
grant execute on dbms_xstream_adm to "STRMADMIN"
/
grant execute on dbms_streams_handler_adm to "STRMADMIN"
/
-- streams views section
grant select on dba_streams_global_rules to "STRMADMIN"
/
grant select on dba_streams_schema_rules to "STRMADMIN"
/
grant select on dba_streams_table_rules to "STRMADMIN"
/
grant select on dba_streams_transform_func tion to "STRMADMIN"
/
grant select on dba_streams_administrator to "STRMADMIN"
/
grant select on dba_streams_message_rules to "STRMADMIN"
/
grant select on dba_streams_message_consum ers to "STRMADMIN"
/
grant select on dba_apply to "STRMADMIN"
/
grant select on dba_apply_parameters to "STRMADMIN"
/
grant select on dba_apply_instantiated_obj ects to "STRMADMIN"
/
grant select on dba_apply_instantiated_sch emas to "STRMADMIN"
/
grant select on dba_apply_instantiated_glo bal to "STRMADMIN"
/
grant select on dba_apply_key_columns to "STRMADMIN"
/
grant select on dba_apply_conflict_columns to "STRMADMIN"
/
grant select on dba_apply_dml_handlers to "STRMADMIN"
/
grant select on dba_apply_progress to "STRMADMIN"
/
grant select on dba_apply_error to "STRMADMIN"
/
grant select on dba_apply_enqueue to "STRMADMIN"
/
grant select on dba_apply_execute to "STRMADMIN"
/
grant select on sys.gv_$streams_apply_coor dinator to "STRMADMIN"
/
grant select on sys.v_$streams_apply_coord inator to "STRMADMIN"
/
grant select on sys.gv_$streams_apply_serv er to "STRMADMIN"
/
grant select on sys.v_$streams_apply_serve r to "STRMADMIN"
/
grant select on sys.gv_$streams_apply_read er to "STRMADMIN"
/
grant select on sys.v_$streams_apply_reade r to "STRMADMIN"
/
grant select on dba_capture to "STRMADMIN"
/
grant select on dba_capture_parameters to "STRMADMIN"
/
grant select on dba_capture_prepared_datab ase to "STRMADMIN"
/
grant select on dba_capture_prepared_schem as to "STRMADMIN"
/
grant select on dba_capture_prepared_table s to "STRMADMIN"
/
grant select on dba_capture_extra_attribut es to "STRMADMIN"
/
grant select on dba_registered_archived_lo g to "STRMADMIN"
/
grant select on sys.gv_$streams_capture to "STRMADMIN"
/
grant select on sys.v_$streams_capture to "STRMADMIN"
/
grant select on dba_rule_sets to "STRMADMIN"
/
grant select on dba_rulesets to "STRMADMIN"
/
grant select on dba_rules to "STRMADMIN"
/
grant select on dba_rule_set_rules to "STRMADMIN"
/
grant select on dba_evaluation_contexts to "STRMADMIN"
/
grant select on dba_evaluation_context_tab les to "STRMADMIN"
/
grant select on dba_evaluation_context_var s to "STRMADMIN"
/
grant select on dba_queue_publishers to "STRMADMIN"
/
grant select on sys.gv_$buffered_queues to "STRMADMIN"
/
grant select on sys.v_$buffered_queues to "STRMADMIN"
/
grant select on sys.gv_$buffered_subscribe rs to "STRMADMIN"
/
grant select on sys.v_$buffered_subscriber s to "STRMADMIN"
/
grant select on sys.gv_$buffered_publisher s to "STRMADMIN"
/
grant select on sys.v_$buffered_publishers to "STRMADMIN"
/
grant select on dba_propagation to "STRMADMIN"
/
-- streams views section
grant select on dba_streams_unsupported to "STRMADMIN"
/
-- streams views section
grant select on dba_streams_newly_supporte d to "STRMADMIN"
/
grant select on dba_streams_rules to "STRMADMIN"
/
grant select on dba_apply_table_columns to "STRMADMIN"
/
grant select on dba_streams_add_column to "STRMADMIN"
/
grant select on dba_streams_delete_column to "STRMADMIN"
/
grant select on dba_streams_rename_column to "STRMADMIN"
/
grant select on dba_streams_rename_schema to "STRMADMIN"
/
grant select on dba_streams_rename_table to "STRMADMIN"
/
grant select on dba_streams_transformation s to "STRMADMIN"
/
grant select on dba_apply_spill_txn to "STRMADMIN"
/
grant select on sys.gv_$streams_transactio n to "STRMADMIN"
/
grant select on sys.v_$streams_transaction to "STRMADMIN"
/
grant select on dba_sync_capture to "STRMADMIN"
/
grant select on dba_sync_capture_prepared_ tabs to "STRMADMIN"
/
grant select on sys.gv_$streams_message_tr acking to "STRMADMIN"
/
grant select on sys.v_$streams_message_tra cking to "STRMADMIN"
/
grant select on DBA_STREAMS_TP_COMPONENT to "STRMADMIN"
/
grant select on DBA_STREAMS_TP_COMPONENT_L INK to "STRMADMIN"
/
grant select on DBA_STREAMS_TP_COMPONENT_S TAT to "STRMADMIN"
/
grant select on DBA_STREAMS_TP_DATABASE to "STRMADMIN"
/
grant select on DBA_STREAMS_TP_PATH_BOTTLE NECK to "STRMADMIN"
/
grant select on DBA_STREAMS_TP_PATH_STAT to "STRMADMIN"
/
grant select on DBA_STREAMS_COLUMNS to "STRMADMIN"
/
grant select on "_DBA_STREAMS_COMPONENT" to "STRMADMIN"
/
grant select on "_DBA_STREAMS_COMPONENT_LI NK" to "STRMADMIN"
/
grant select on "_DBA_STREAMS_COMPONENT_PR OP" to "STRMADMIN"
/
grant select on "_DBA_STREAMS_COMPONENT_ST AT" to "STRMADMIN"
/
grant select on "_DBA_STREAMS_COMPONENT_EV ENT" to "STRMADMIN"
/
grant select on "_DBA_STREAMS_TP_COMPONENT _PROP" to "STRMADMIN"
/
grant select on dba_streams_keep_columns to "STRMADMIN"
/
grant select on dba_streams_split_merge to "STRMADMIN"
/
grant select on dba_streams_split_merge_hi st to "STRMADMIN"
/
grant select on dba_comparison to "STRMADMIN"
/
grant select on dba_comparison_columns to "STRMADMIN"
/
grant select on dba_comparison_row_dif to "STRMADMIN"
/
grant select on dba_comparison_scan to "STRMADMIN"
/
grant select on dba_comparison_scan_values to "STRMADMIN"
/
grant select on dba_recoverable_script to "STRMADMIN"
/
grant select on dba_recoverable_script_blo cks to "STRMADMIN"
/
grant select on dba_recoverable_script_err ors to "STRMADMIN"
/
grant select on dba_recoverable_script_his t to "STRMADMIN"
/
grant select on dba_recoverable_script_par ams to "STRMADMIN"
/
grant select on dba_comparison_scan_summar y to "STRMADMIN"
/
grant select on dba_xstream_inbound to "STRMADMIN"
/
grant select on dba_xstream_outbound to "STRMADMIN"
/
grant select on dba_xstream_inbound_progre ss to "STRMADMIN"
/
grant select on dba_xstream_outbound_progr ess to "STRMADMIN"
/
grant select on dba_xstream_rules to "STRMADMIN"
/
grant select on dba_streams_stmt_handlers to "STRMADMIN"
/
grant select on dba_streams_stmts to "STRMADMIN"
/
grant select on dba_apply_change_handlers to "STRMADMIN"
/
grant select on sys.gv_$streams_pool_stati stics to "STRMADMIN"
/
grant select on sys.v_$streams_pool_statis tics to "STRMADMIN"
/
-- miscellaneous privileges section
grant restricted session to "STRMADMIN"
/
grant execute on dbms_flashback to "STRMADMIN"
/
BEGIN
dbms_streams_auth.grant_re mote_admin _access('" STRMADMIN" ');
END;
/
grant select_catalog_role to "STRMADMIN"
/
grant select on DBA_DB_LINKS to "STRMADMIN"
/
grant select on DBA_SCHEDULER_JOBS to "STRMADMIN"
/
what is next to created oracle streams
BEGIN
DBMS_STREAMS_AUTH.GRANT_AD
grantee => 'strmadmin',
grant_privileges => FALSE,
file_name => 'grant_strms_privs.sql',
directory_name => 'admin_dir');
END;
/
-- rule privileges section
grant execute on dbms_rule_adm to "STRMADMIN"
/
BEGIN
dbms_rule_adm.grant_system
privilege => dbms_rule_adm.CREATE_EVALU
grantee => '"STRMADMIN"',
grant_option => true);
END;
/
BEGIN
dbms_rule_adm.grant_system
privilege => dbms_rule_adm.CREATE_RULE_
grantee => '"STRMADMIN"',
grant_option => true);
END;
/
BEGIN
dbms_rule_adm.grant_system
privilege => dbms_rule_adm.CREATE_RULE_
grantee => '"STRMADMIN"',
grant_option => true);
END;
/
BEGIN
dbms_rule_adm.grant_system
privilege => dbms_rule_adm.CREATE_ANY_R
grantee => '"STRMADMIN"',
grant_option => true);
END;
/
BEGIN
dbms_rule_adm.grant_system
privilege => dbms_rule_adm.ALTER_ANY_RU
grantee => '"STRMADMIN"',
grant_option => true);
END;
/
BEGIN
dbms_rule_adm.grant_system
privilege => dbms_rule_adm.EXECUTE_ANY_
grantee => '"STRMADMIN"',
grant_option => true);
END;
/
BEGIN
dbms_rule_adm.grant_system
privilege => dbms_rule_adm.CREATE_ANY_R
grantee => '"STRMADMIN"',
grant_option => true);
END;
/
BEGIN
dbms_rule_adm.grant_system
privilege => dbms_rule_adm.ALTER_ANY_RU
grantee => '"STRMADMIN"',
grant_option => true);
END;
/
BEGIN
dbms_rule_adm.grant_system
privilege => dbms_rule_adm.EXECUTE_ANY_
grantee => '"STRMADMIN"',
grant_option => true);
END;
/
-- queue privileges section
grant execute on dbms_aq to "STRMADMIN"
/
grant execute on dbms_aqadm to "STRMADMIN"
/
BEGIN
dbms_aqadm.grant_system_pr
'ENQUEUE_ANY',
'"STRMADMIN"',
admin_option => TRUE);
END;
/
BEGIN
dbms_aqadm.grant_system_pr
'DEQUEUE_ANY',
'"STRMADMIN"',
admin_option => TRUE);
END;
/
BEGIN
dbms_aqadm.grant_system_pr
'MANAGE_ANY',
'"STRMADMIN"',
TRUE);
END;
/
grant select on dba_queue_tables to "STRMADMIN"
/
grant select on dba_queues to "STRMADMIN"
/
grant select on dba_queue_schedules to "STRMADMIN"
/
grant select on sys.v_$aq to "STRMADMIN"
/
grant select on sys.gv_$aq to "STRMADMIN"
/
grant select on sys.aq$_propagation_status
/
grant execute on sys.dbms_aqin to "STRMADMIN"
/
grant select on sys.aq$internet_users to "STRMADMIN"
/
grant execute on sys.dbms_transform to "STRMADMIN"
/
grant execute on sys.dbms_aqelm to "STRMADMIN"
/
grant select on dba_aq_agents to "STRMADMIN"
/
grant select on dba_aq_agent_privs to "STRMADMIN"
/
grant select on dba_queue_subscribers to "STRMADMIN"
/
-- streams packages section
grant execute on dbms_capture_adm to "STRMADMIN"
/
grant execute on dbms_propagation_adm to "STRMADMIN"
/
grant execute on dbms_apply_adm to "STRMADMIN"
/
grant execute on dbms_streams_adm to "STRMADMIN"
/
grant execute on dbms_streams_messaging to "STRMADMIN"
/
grant execute on dbms_streams_advisor_adm to "STRMADMIN"
/
grant execute on dbms_capture_switch_adm to "STRMADMIN"
/
grant execute on dbms_xstream_adm to "STRMADMIN"
/
grant execute on dbms_streams_handler_adm to "STRMADMIN"
/
-- streams views section
grant select on dba_streams_global_rules to "STRMADMIN"
/
grant select on dba_streams_schema_rules to "STRMADMIN"
/
grant select on dba_streams_table_rules to "STRMADMIN"
/
grant select on dba_streams_transform_func
/
grant select on dba_streams_administrator to "STRMADMIN"
/
grant select on dba_streams_message_rules to "STRMADMIN"
/
grant select on dba_streams_message_consum
/
grant select on dba_apply to "STRMADMIN"
/
grant select on dba_apply_parameters to "STRMADMIN"
/
grant select on dba_apply_instantiated_obj
/
grant select on dba_apply_instantiated_sch
/
grant select on dba_apply_instantiated_glo
/
grant select on dba_apply_key_columns to "STRMADMIN"
/
grant select on dba_apply_conflict_columns
/
grant select on dba_apply_dml_handlers to "STRMADMIN"
/
grant select on dba_apply_progress to "STRMADMIN"
/
grant select on dba_apply_error to "STRMADMIN"
/
grant select on dba_apply_enqueue to "STRMADMIN"
/
grant select on dba_apply_execute to "STRMADMIN"
/
grant select on sys.gv_$streams_apply_coor
/
grant select on sys.v_$streams_apply_coord
/
grant select on sys.gv_$streams_apply_serv
/
grant select on sys.v_$streams_apply_serve
/
grant select on sys.gv_$streams_apply_read
/
grant select on sys.v_$streams_apply_reade
/
grant select on dba_capture to "STRMADMIN"
/
grant select on dba_capture_parameters to "STRMADMIN"
/
grant select on dba_capture_prepared_datab
/
grant select on dba_capture_prepared_schem
/
grant select on dba_capture_prepared_table
/
grant select on dba_capture_extra_attribut
/
grant select on dba_registered_archived_lo
/
grant select on sys.gv_$streams_capture to "STRMADMIN"
/
grant select on sys.v_$streams_capture to "STRMADMIN"
/
grant select on dba_rule_sets to "STRMADMIN"
/
grant select on dba_rulesets to "STRMADMIN"
/
grant select on dba_rules to "STRMADMIN"
/
grant select on dba_rule_set_rules to "STRMADMIN"
/
grant select on dba_evaluation_contexts to "STRMADMIN"
/
grant select on dba_evaluation_context_tab
/
grant select on dba_evaluation_context_var
/
grant select on dba_queue_publishers to "STRMADMIN"
/
grant select on sys.gv_$buffered_queues to "STRMADMIN"
/
grant select on sys.v_$buffered_queues to "STRMADMIN"
/
grant select on sys.gv_$buffered_subscribe
/
grant select on sys.v_$buffered_subscriber
/
grant select on sys.gv_$buffered_publisher
/
grant select on sys.v_$buffered_publishers
/
grant select on dba_propagation to "STRMADMIN"
/
-- streams views section
grant select on dba_streams_unsupported to "STRMADMIN"
/
-- streams views section
grant select on dba_streams_newly_supporte
/
grant select on dba_streams_rules to "STRMADMIN"
/
grant select on dba_apply_table_columns to "STRMADMIN"
/
grant select on dba_streams_add_column to "STRMADMIN"
/
grant select on dba_streams_delete_column to "STRMADMIN"
/
grant select on dba_streams_rename_column to "STRMADMIN"
/
grant select on dba_streams_rename_schema to "STRMADMIN"
/
grant select on dba_streams_rename_table to "STRMADMIN"
/
grant select on dba_streams_transformation
/
grant select on dba_apply_spill_txn to "STRMADMIN"
/
grant select on sys.gv_$streams_transactio
/
grant select on sys.v_$streams_transaction
/
grant select on dba_sync_capture to "STRMADMIN"
/
grant select on dba_sync_capture_prepared_
/
grant select on sys.gv_$streams_message_tr
/
grant select on sys.v_$streams_message_tra
/
grant select on DBA_STREAMS_TP_COMPONENT to "STRMADMIN"
/
grant select on DBA_STREAMS_TP_COMPONENT_L
/
grant select on DBA_STREAMS_TP_COMPONENT_S
/
grant select on DBA_STREAMS_TP_DATABASE to "STRMADMIN"
/
grant select on DBA_STREAMS_TP_PATH_BOTTLE
/
grant select on DBA_STREAMS_TP_PATH_STAT to "STRMADMIN"
/
grant select on DBA_STREAMS_COLUMNS to "STRMADMIN"
/
grant select on "_DBA_STREAMS_COMPONENT" to "STRMADMIN"
/
grant select on "_DBA_STREAMS_COMPONENT_LI
/
grant select on "_DBA_STREAMS_COMPONENT_PR
/
grant select on "_DBA_STREAMS_COMPONENT_ST
/
grant select on "_DBA_STREAMS_COMPONENT_EV
/
grant select on "_DBA_STREAMS_TP_COMPONENT
/
grant select on dba_streams_keep_columns to "STRMADMIN"
/
grant select on dba_streams_split_merge to "STRMADMIN"
/
grant select on dba_streams_split_merge_hi
/
grant select on dba_comparison to "STRMADMIN"
/
grant select on dba_comparison_columns to "STRMADMIN"
/
grant select on dba_comparison_row_dif to "STRMADMIN"
/
grant select on dba_comparison_scan to "STRMADMIN"
/
grant select on dba_comparison_scan_values
/
grant select on dba_recoverable_script to "STRMADMIN"
/
grant select on dba_recoverable_script_blo
/
grant select on dba_recoverable_script_err
/
grant select on dba_recoverable_script_his
/
grant select on dba_recoverable_script_par
/
grant select on dba_comparison_scan_summar
/
grant select on dba_xstream_inbound to "STRMADMIN"
/
grant select on dba_xstream_outbound to "STRMADMIN"
/
grant select on dba_xstream_inbound_progre
/
grant select on dba_xstream_outbound_progr
/
grant select on dba_xstream_rules to "STRMADMIN"
/
grant select on dba_streams_stmt_handlers to "STRMADMIN"
/
grant select on dba_streams_stmts to "STRMADMIN"
/
grant select on dba_apply_change_handlers to "STRMADMIN"
/
grant select on sys.gv_$streams_pool_stati
/
grant select on sys.v_$streams_pool_statis
/
-- miscellaneous privileges section
grant restricted session to "STRMADMIN"
/
grant execute on dbms_flashback to "STRMADMIN"
/
BEGIN
dbms_streams_auth.grant_re
END;
/
grant select_catalog_role to "STRMADMIN"
/
grant select on DBA_DB_LINKS to "STRMADMIN"
/
grant select on DBA_SCHEDULER_JOBS to "STRMADMIN"
/
Is there any particular error you are getting or thing which is stopping for the streams configuration. You can put that. That will help in resolving your problem more easliy.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
yes
Now what u need is creating rules, and then instantiation.. Are you propagating at table or schema level?