rem ----------------------------------------------------------------------
rem -- 2006 DataPRO Developers - m@urelio
rem ----------------------------------------------------------------------
rem -- Script para criação do usuário NK e concessão de privilégios de DBA
rem -- Execute como usuário SYS.
rem -- RDBMS Version 11g XE express
rem ----------------------------------------------------------------------

rem ----------------------------------------------------------------------
rem -- CREATE USER NK
rem ----------------------------------------------------------------------
create user nk identified by manager
default tablespace usr
temporary tablespace tmp;

rem ----------------------------------------------------------------------
rem -- GRANTS SYSTEM ROLES TO NK
rem ----------------------------------------------------------------------
grant dba to nk;
grant resource to nk;
grant connect to nk;
grant select_catalog_role to nk;
grant execute_catalog_role to nk;
grant delete_catalog_role to nk;
grant imp_full_database to nk;
grant exp_full_database to nk;
grant recovery_catalog_owner to nk;
grant aq_administrator_role to nk;
grant aq_user_role to nk;
grant snmpagent to nk;

rem ----------------------------------------------------------------------
rem -- TABLES
rem ----------------------------------------------------------------------
grant select on access$ to nk;
grant select on aq$_message_types to nk;
grant select on aq$_queue_statistics to nk;
grant select on argument$ to nk;
grant select on atemptab$ to nk;
grant select on attrcol$ to nk;
grant select on attribute$ to nk;
grant select on aud$ to nk;
grant select on audit$ to nk;
grant select on audit_actions to nk;
grant select on bootstrap$ to nk;
grant select on ccol$ to nk;
grant select on cdef$ to nk;
grant select on clu$ to nk;
grant select on col$ to nk;
grant select on collection$ to nk;
grant select on coltype$ to nk;
grant select on com$ to nk;
grant select on con$ to nk;
grant select on dbms_alert_info to nk;
grant select on dbms_lock_allocated to nk;
grant select on defrole$ to nk;
grant select on dependency$ to nk;
grant select on dir$ to nk;
grant select on dual to nk;
grant select on duc$ to nk;
grant select on error$ to nk;
grant select on expact$ to nk;
grant select on fet$ to nk;
grant select on file$ to nk;
grant select on histgrm$ to nk;
grant select on hist_head$ to nk;
grant select on icol$ to nk;
grant select on idl_char$ to nk;
grant select on idl_sb4$ to nk;
grant select on idl_ub1$ to nk;
grant select on idl_ub2$ to nk;
grant select on id_gens$ to nk;
grant select on incexp to nk;
grant select on incfil to nk;
grant select on incvid to nk;
grant select on ind$ to nk;
grant select on indpart$ to nk;
grant select on job$ to nk;
grant select on kopm$ to nk;
grant select on lab$ to nk;
grant select on library$ to nk;
grant select on link$ to nk;
grant select on lob$ to nk;
grant select on method$ to nk;
grant select on migrate$ to nk;
grant select on mlog$ to nk;
grant select on mlog_refcol$ to nk;
grant select on noexp$ to nk;
grant select on ntab$ to nk;
grant select on obj$ to nk;
grant select on objauth$ to nk;
grant select on objpriv$ to nk;
grant select on oid$ to nk;
grant select on parameter$ to nk;
grant select on partcol$ to nk;
grant select on partobj$ to nk;
grant select on pending_sessions$ to nk;
grant select on pending_sub_sessions$ to nk;
grant select on pending_trans$ to nk;
grant select on procedure$ to nk;
grant select on profile$ to nk;
grant select on profname$ to nk;
grant select on props$ to nk;
grant select on pstubtbl to nk;
grant select on refcon$ to nk;
grant select on reg_snap$ to nk;
grant select on resource_cost$ to nk;
grant select on resource_map to nk;
grant select on result$ to nk;
grant select on rgchild$ to nk;
grant select on rgroup$ to nk;
grant select on seg$ to nk;
grant select on seq$ to nk;
grant select on slog$ to nk;
grant select on snap$ to nk;
grant select on snap_colmap$ to nk;
grant select on snap_refop$ to nk;
grant select on snap_reftime$ to nk;
grant select on source$ to nk;
grant select on stmt_audit_option_map to nk;
grant select on syn$ to nk;
grant select on sysauth$ to nk;
grant select on system_privilege_map to nk;
grant select on tab$ to nk;
grant select on table_privilege_map to nk;
grant select on tabpart$ to nk;
grant select on trigger$ to nk;
grant select on triggercol$ to nk;
grant select on trusted_list$ to nk;
grant select on ts$ to nk;
grant select on tsq$ to nk;
grant select on type$ to nk;
grant select on typed_view$ to nk;
grant select on type_misc$ to nk;
grant select on uet$ to nk;
grant select on ugroup$ to nk;
grant select on undo$ to nk;
grant select on user$ to nk;
grant select on user_astatus_map to nk;
grant select on user_history$ to nk;
grant select on view$ to nk;

rem ----------------------------------------------------------------------
rem -- VIEWS
rem ----------------------------------------------------------------------
grant select on all_all_tables to nk;
grant select on all_arguments to nk;
grant select on all_catalog to nk;
grant select on all_clusters to nk;
grant select on all_cluster_hash_expressions to nk;
grant select on all_coll_types to nk;
grant select on all_col_comments to nk;
grant select on all_col_privs to nk;
grant select on all_col_privs_made to nk;
grant select on all_col_privs_recd to nk;
grant select on all_constraints to nk;
grant select on all_cons_columns to nk;
grant select on all_db_links to nk;
grant select on all_def_audit_opts to nk;
grant select on all_dependencies to nk;
grant select on all_directories to nk;
grant select on all_errors to nk;
grant select on all_indexes to nk;
grant select on all_ind_columns to nk;
grant select on all_ind_partitions to nk;
grant select on all_libraries to nk;
grant select on all_lobs to nk;
grant select on all_method_params to nk;
grant select on all_method_results to nk;
grant select on all_nested_tables to nk;
grant select on all_objects to nk;
grant select on all_object_tables to nk;
grant select on all_part_col_statistics to nk;
grant select on all_part_histograms to nk;
grant select on all_part_indexes to nk;
grant select on all_part_key_columns to nk;
grant select on all_part_tables to nk;
grant select on all_probe_objects to nk;
grant select on all_refresh to nk;
grant select on all_refresh_children to nk;
grant select on all_refs to nk;
grant select on all_registered_snapshots to nk;
grant select on all_sequences to nk;
grant select on all_snapshots to nk;
grant select on all_snapshot_logs to nk;
grant select on all_snapshot_refresh_times to nk;
grant select on all_source to nk;
grant select on all_synonyms to nk;
grant select on all_tables to nk;
grant select on all_tab_columns to nk;
grant select on all_tab_col_statistics to nk;
grant select on all_tab_comments to nk;
grant select on all_tab_histograms to nk;
grant select on all_tab_partitions to nk;
grant select on all_tab_privs to nk;
grant select on all_tab_privs_made to nk;
grant select on all_tab_privs_recd to nk;
grant select on all_triggers to nk;
grant select on all_trigger_cols to nk;
grant select on all_types to nk;
grant select on all_type_attrs to nk;
grant select on all_type_methods to nk;
grant select on all_updatable_columns to nk;
grant select on all_users to nk;
grant select on all_views to nk;
grant select on catalog to nk;
grant select on code_pieces to nk;
grant select on code_size to nk;
grant select on col to nk;
grant select on column_privileges to nk;
grant select on dba_2pc_neighbors to nk;
grant select on dba_2pc_pending to nk;
grant select on dba_all_tables to nk;
grant select on dba_analyze_objects to nk;
grant select on dba_audit_exists to nk;
grant select on dba_audit_object to nk;
grant select on dba_audit_session to nk;
grant select on dba_audit_statement to nk;
grant select on dba_audit_trail to nk;
grant select on dba_catalog to nk;
grant select on dba_clusters to nk;
grant select on dba_cluster_hash_expressions to nk;
grant select on dba_clu_columns to nk;
grant select on dba_coll_types to nk;
grant select on dba_col_comments to nk;
grant select on dba_col_privs to nk;
grant select on dba_constraints to nk;
grant select on dba_cons_columns to nk;
grant select on dba_data_files to nk;
grant select on dba_db_links to nk;
grant select on dba_dependencies to nk;
grant select on dba_directories to nk;
grant select on dba_errors to nk;
grant select on dba_exp_files to nk;
grant select on dba_exp_objects to nk;
grant select on dba_exp_version to nk;
grant select on dba_extents to nk;
grant select on dba_free_space to nk;
grant select on dba_free_space_coalesced to nk;
grant select on dba_free_space_coalesced_tmp1 to nk;
grant select on dba_free_space_coalesced_tmp2 to nk;
grant select on dba_indexes to nk;
grant select on dba_ind_columns to nk;
grant select on dba_ind_partitions to nk;
grant select on dba_jobs to nk;
grant select on dba_jobs_running to nk;
grant select on dba_libraries to nk;
grant select on dba_lobs to nk;
grant select on dba_method_params to nk;
grant select on dba_method_results to nk;
grant select on dba_nested_tables to nk;
grant select on dba_objects to nk;
grant select on dba_object_size to nk;
grant select on dba_object_tables to nk;
grant select on dba_obj_audit_opts to nk;
grant select on dba_part_col_statistics to nk;
grant select on dba_part_histograms to nk;
grant select on dba_part_indexes to nk;
grant select on dba_part_key_columns to nk;
grant select on dba_part_tables to nk;
grant select on dba_pending_transactions to nk;
grant select on dba_priv_audit_opts to nk;
grant select on dba_profiles to nk;
grant select on dba_queues to nk;
grant select on dba_queue_schedules to nk;
grant select on dba_queue_tables to nk;
grant select on dba_rchild to nk;
grant select on dba_refresh to nk;
grant select on dba_refresh_children to nk;
grant select on dba_refs to nk;
grant select on dba_registered_snapshots to nk;
grant select on dba_rgroup to nk;
grant select on dba_roles to nk;
grant select on dba_role_privs to nk;
grant select on dba_rollback_segs to nk;
grant select on dba_segments to nk;
grant select on dba_sequences to nk;
grant select on dba_snapshots to nk;
grant select on dba_snapshot_logs to nk;
grant select on dba_snapshot_log_filter_cols to nk;
grant select on dba_snapshot_refresh_times to nk;
grant select on dba_source to nk;
grant select on dba_stmt_audit_opts to nk;
grant select on dba_synonyms to nk;
grant select on dba_sys_privs to nk;
grant select on dba_tables to nk;
grant select on dba_tablespaces to nk;
grant select on dba_tab_columns to nk;
grant select on dba_tab_col_statistics to nk;
grant select on dba_tab_comments to nk;
grant select on dba_tab_histograms to nk;
grant select on dba_tab_partitions to nk;
grant select on dba_tab_privs to nk;
grant select on dba_triggers to nk;
grant select on dba_trigger_cols to nk;
grant select on dba_ts_quotas to nk;
grant select on dba_types to nk;
grant select on dba_type_attrs to nk;
grant select on dba_type_methods to nk;
grant select on dba_updatable_columns to nk;
grant select on dba_users to nk;
grant select on dba_views to nk;
grant select on defdefaultdest to nk;
grant select on deferrcount to nk;
grant select on deferror to nk;
grant select on deflob to nk;
grant select on defpropagator to nk;
grant select on defschedule to nk;
grant select on deftran to nk;
grant select on deftrandest to nk;
grant select on dictionary to nk;
grant select on dict_columns to nk;
grant select on disk_and_fixed_objects to nk;
grant select on error_size to nk;
grant select on exu8anal to nk;
grant select on exu8aud to nk;
grant select on exu8bsz to nk;
grant select on exu8ccl to nk;
grant select on exu8cclo to nk;
grant select on exu8cclu to nk;
grant select on exu8cco to nk;
grant select on exu8ccou to nk;
grant select on exu8cgr to nk;
grant select on exu8cgru to nk;
grant select on exu8clu to nk;
grant select on exu8cluc to nk;
grant select on exu8clui to nk;
grant select on exu8cluu to nk;
grant select on exu8cmt to nk;
grant select on exu8cmtu to nk;
grant select on exu8coe to nk;
grant select on exu8coeu to nk;
grant select on exu8col to nk;
grant select on exu8colnn to nk;
grant select on exu8colu to nk;
grant select on exu8col_temp to nk;
grant select on exu8con to nk;
grant select on exu8conu to nk;
grant select on exu8coo to nk;
grant select on exu8coou to nk;
grant select on exu8cpo to nk;
grant select on exu8cset to nk;
grant select on exu8csn to nk;
grant select on exu8csnu to nk;
grant select on exu8del to nk;
grant select on exu8delsnap to nk;
grant select on exu8delsnapl to nk;
grant select on exu8dfr to nk;
grant select on exu8dir to nk;
grant select on exu8erc to nk;
grant select on exu8fil to nk;
grant select on exu8fpt to nk;
grant select on exu8fptu to nk;
grant select on exu8ful to nk;
grant select on exu8glob to nk;
grant select on exu8grn to nk;
grant select on exu8grnu to nk;
grant select on exu8grs to nk;
grant select on exu8ico to nk;
grant select on exu8icou to nk;
grant select on exu8ind to nk;
grant select on exu8indc to nk;
grant select on exu8indi to nk;
grant select on exu8indic to nk;
grant select on exu8indu to nk;
grant select on exu8ink to nk;
grant select on exu8inku to nk;
grant select on exu8iov to nk;
grant select on exu8iovu to nk;
grant select on exu8ixp to nk;
grant select on exu8ixpu to nk;
grant select on exu8jbq to nk;
grant select on exu8jbqu to nk;
grant select on exu8lib to nk;
grant select on exu8libu to nk;
grant select on exu8lnk to nk;
grant select on exu8lnku to nk;
grant select on exu8lob to nk;
grant select on exu8lobu to nk;
grant select on exu8ntb to nk;
grant select on exu8ntbu to nk;
grant select on exu8nxp to nk;
grant select on exu8nxpu to nk;
grant select on exu8oid to nk;
grant select on exu8oidu to nk;
grant select on exu8opt to nk;
grant select on exu8ord to nk;
grant select on exu8ordu to nk;
grant select on exu8pds to nk;
grant select on exu8pdsu to nk;
grant select on exu8phs to nk;
grant select on exu8pnt to nk;
grant select on exu8pntu to nk;
grant select on exu8pok to nk;
grant select on exu8poki to nk;
grant select on exu8pokiu to nk;
grant select on exu8poku to nk;
grant select on exu8prf to nk;
grant select on exu8prr to nk;
grant select on exu8pst to nk;
grant select on exu8pstc to nk;
grant select on exu8psti to nk;
grant select on exu8pstic to nk;
grant select on exu8pstu to nk;
grant select on exu8pvf to nk;
grant select on exu8ref to nk;
grant select on exu8refc to nk;
grant select on exu8refi to nk;
grant select on exu8refic to nk;
grant select on exu8refu to nk;
grant select on exu8rfs to nk;
grant select on exu8rfsu to nk;
grant select on exu8rgc to nk;
grant select on exu8rgcu to nk;
grant select on exu8rgs to nk;
grant select on exu8rgsu to nk;
grant select on exu8rif to nk;
grant select on exu8rlg to nk;
grant select on exu8rol to nk;
grant select on exu8rsg to nk;
grant select on exu8scm to nk;
grant select on exu8scmu to nk;
grant select on exu8seq to nk;
grant select on exu8sequ to nk;
grant select on exu8slfc to nk;
grant select on exu8slfcu to nk;
grant select on exu8slog to nk;
grant select on exu8slogu to nk;
grant select on exu8snap to nk;
grant select on exu8snapc to nk;
grant select on exu8snapi to nk;
grant select on exu8snapl to nk;
grant select on exu8snaplc to nk;
grant select on exu8snapli to nk;
grant select on exu8snaplu to nk;
grant select on exu8snapu to nk;
grant select on exu8spr to nk;
grant select on exu8sprc to nk;
grant select on exu8spri to nk;
grant select on exu8sps to nk;
grant select on exu8spsu to nk;
grant select on exu8spu to nk;
grant select on exu8spv to nk;
grant select on exu8srt to nk;
grant select on exu8srtu to nk;
grant select on exu8sto to nk;
grant select on exu8stou to nk;
grant select on exu8syn to nk;
grant select on exu8sync to nk;
grant select on exu8syni to nk;
grant select on exu8synu to nk;
grant select on exu8tab to nk;
grant select on exu8tabc to nk;
grant select on exu8tabi to nk;
grant select on exu8tabu to nk;
grant select on exu8tbp to nk;
grant select on exu8tbpu to nk;
grant select on exu8tbs to nk;
grant select on exu8tgr to nk;
grant select on exu8tgrc to nk;
grant select on exu8tgri to nk;
grant select on exu8tgric to nk;
grant select on exu8tgru to nk;
grant select on exu8tne to nk;
grant select on exu8tntc to nk;
grant select on exu8tnti to nk;
grant select on exu8tntic to nk;
grant select on exu8tsl to nk;
grant select on exu8tsn to nk;
grant select on exu8tsq to nk;
grant select on exu8typ to nk;
grant select on exu8typb to nk;
grant select on exu8typbu to nk;
grant select on exu8typt to nk;
grant select on exu8typtu to nk;
grant select on exu8typu to nk;
grant select on exu8uscu to nk;
grant select on exu8usr to nk;
grant select on exu8usru to nk;
grant select on exu8vdpt to nk;
grant select on exu8vdptu to nk;
grant select on exu8ver to nk;
grant select on exu8vew to nk;
grant select on exu8vewc to nk;
grant select on exu8vewi to nk;
grant select on exu8vewu to nk;
grant select on exu8vinf to nk;
grant select on exu8vinfc to nk;
grant select on exu8vinfi to nk;
grant select on exu8vinfu to nk;
grant select on exu8vnc to nk;
grant select on exu8vncc to nk;
grant select on exu8vnci to nk;
grant select on exu8vncu to nk;
grant select on filext$ to nk;
grant select on global_name to nk;
grant select on gv_$access to nk;
grant select on gv_$active_instances to nk;
grant select on gv_$aq to nk;
grant select on gv_$aq1 to nk;
grant select on gv_$archive to nk;
grant select on gv_$archived_log to nk;
grant select on gv_$archive_dest to nk;
grant select on gv_$backup to nk;
grant select on gv_$backup_corruption to nk;
grant select on gv_$backup_datafile to nk;
grant select on gv_$backup_device to nk;
grant select on gv_$backup_piece to nk;
grant select on gv_$backup_redolog to nk;
grant select on gv_$backup_set to nk;
grant select on gv_$bgprocess to nk;
grant select on gv_$bh to nk;
grant select on gv_$buffer_pool to nk;
grant select on gv_$circuit to nk;
grant select on gv_$class_ping to nk;
grant select on gv_$compatibility to nk;
grant select on gv_$compatseg to nk;
grant select on gv_$controlfile to nk;
grant select on gv_$controlfile_record_section to nk;
grant select on gv_$copy_corruption to nk;
grant select on gv_$current_bucket to nk;
grant select on gv_$database to nk;
grant select on gv_$datafile to nk;
grant select on gv_$datafile_copy to nk;
grant select on gv_$datafile_header to nk;
grant select on gv_$dbfile to nk;
grant select on gv_$dblink to nk;
grant select on gv_$db_object_cache to nk;
grant select on gv_$db_pipes to nk;
grant select on gv_$deleted_object to nk;
grant select on gv_$dispatcher to nk;
grant select on gv_$dispatcher_rate to nk;
grant select on gv_$dlm_convert_local to nk;
grant select on gv_$dlm_convert_remote to nk;
grant select on gv_$dlm_latch to nk;
grant select on gv_$dlm_locks to nk;
grant select on gv_$dlm_misc to nk;
grant select on gv_$enabledprivs to nk;
grant select on gv_$enqueue_lock to nk;
grant select on gv_$event_name to nk;
grant select on gv_$execution to nk;
grant select on gv_$filestat to nk;
grant select on gv_$file_ping to nk;
grant select on gv_$fixed_table to nk;
grant select on gv_$fixed_view_definition to nk;
grant select on gv_$global_transaction to nk;
grant select on gv_$indexed_fixed_column to nk;
grant select on gv_$instance to nk;
grant select on gv_$latch to nk;
grant select on gv_$latchholder to nk;
grant select on gv_$latchname to nk;
grant select on gv_$latch_children to nk;
grant select on gv_$latch_misses to nk;
grant select on gv_$latch_parent to nk;
grant select on gv_$librarycache to nk;
grant select on gv_$license to nk;
grant select on gv_$loadcstat to nk;
grant select on gv_$loadpstat to nk;
grant select on gv_$loadtstat to nk;
grant select on gv_$lock to nk;
grant select on gv_$locked_object to nk;
grant select on gv_$locks_with_collisions to nk;
grant select on gv_$lock_activity to nk;
grant select on gv_$lock_element to nk;
grant select on gv_$log to nk;
grant select on gv_$logfile to nk;
grant select on gv_$loghist to nk;
grant select on gv_$log_history to nk;
grant select on gv_$mls_parameters to nk;
grant select on gv_$mts to nk;
grant select on gv_$mystat to nk;
grant select on gv_$nls_parameters to nk;
grant select on gv_$nls_valid_values to nk;
grant select on gv_$object_dependency to nk;
grant select on gv_$offline_range to nk;
grant select on gv_$open_cursor to nk;
grant select on gv_$option to nk;
grant select on gv_$parameter to nk;
grant select on gv_$pq_sesstat to nk;
grant select on gv_$pq_slave to nk;
grant select on gv_$pq_sysstat to nk;
grant select on gv_$pq_tqstat to nk;
grant select on gv_$process to nk;
grant select on gv_$pwfile_users to nk;
grant select on gv_$queue to nk;
grant select on gv_$recent_bucket to nk;
grant select on gv_$recovery_file_status to nk;
grant select on gv_$recovery_log to nk;
grant select on gv_$recovery_progress to nk;
grant select on gv_$recovery_status to nk;
grant select on gv_$recover_file to nk;
grant select on gv_$reqdist to nk;
grant select on gv_$resource to nk;
grant select on gv_$resource_limit to nk;
grant select on gv_$rollstat to nk;
grant select on gv_$rowcache to nk;
grant select on gv_$rowcache_parent to nk;
grant select on gv_$rowcache_subordinate to nk;
grant select on gv_$session to nk;
grant select on gv_$session_connect_info to nk;
grant select on gv_$session_cursor_cache to nk;
grant select on gv_$session_event to nk;
grant select on gv_$session_longops to nk;
grant select on gv_$session_object_cache to nk;
grant select on gv_$session_wait to nk;
grant select on gv_$sesstat to nk;
grant select on gv_$sess_io to nk;
grant select on gv_$sga to nk;
grant select on gv_$sgastat to nk;
grant select on gv_$shared_pool_reserved to nk;
grant select on gv_$shared_server to nk;
grant select on gv_$sort_segment to nk;
grant select on gv_$sort_usage to nk;
grant select on gv_$sql to nk;
grant select on gv_$sqlarea to nk;
grant select on gv_$sqltext to nk;
grant select on gv_$sqltext_with_newlines to nk;
grant select on gv_$sql_bind_data to nk;
grant select on gv_$sql_bind_metadata to nk;
grant select on gv_$sql_cursor to nk;
grant select on gv_$sql_shared_memory to nk;
grant select on gv_$statname to nk;
grant select on gv_$subcache to nk;
grant select on gv_$sysstat to nk;
grant select on gv_$system_cursor_cache to nk;
grant select on gv_$system_event to nk;
grant select on gv_$system_parameter to nk;
grant select on gv_$tablespace to nk;
grant select on gv_$thread to nk;
grant select on gv_$timer to nk;
grant select on gv_$transaction to nk;
grant select on gv_$transaction_enqueue to nk;
grant select on gv_$type_size to nk;
grant select on gv_$version to nk;
grant select on gv_$waitstat to nk;
grant select on gv_$_lock to nk;
grant select on imp8cdt to nk;
grant select on imp8cdtu to nk;
grant select on imp8repcat to nk;
grant select on imp8ttd to nk;
grant select on imp8ttdu to nk;
grant select on imp8uec to nk;
grant select on index_histogram to nk;
grant select on index_stats to nk;
grant select on loader_constraint_info to nk;
grant select on loader_file_ts to nk;
grant select on loader_param_info to nk;
grant select on loader_part_info to nk;
grant select on loader_tab_info to nk;
grant select on loader_trigger_info to nk;
grant select on nls_database_parameters to nk;
grant select on nls_instance_parameters to nk;
grant select on nls_session_parameters to nk;
grant select on ora_kglr7_db_links to nk;
grant select on ora_kglr7_dependencies to nk;
grant select on ora_kglr7_idl_char to nk;
grant select on ora_kglr7_idl_sb4 to nk;
grant select on ora_kglr7_idl_ub1 to nk;
grant select on ora_kglr7_idl_ub2 to nk;
grant select on ora_kglr7_objects to nk;
grant select on order_object_by_dependency to nk;
grant select on parsed_pieces to nk;
grant select on parsed_size to nk;
grant select on product_component_version to nk;
grant select on ps1$ to nk;
grant select on pss1$ to nk;
grant select on publicsyn to nk;
grant select on public_dependency to nk;
grant select on resource_cost to nk;
grant select on role_role_privs to nk;
grant select on role_sys_privs to nk;
grant select on role_tab_privs to nk;
grant select on session_privs to nk;
grant select on session_roles to nk;
grant select on sm$audit_config to nk;
grant select on sm$integrity_cons to nk;
grant select on sm$ts_avail to nk;
grant select on sm$ts_free to nk;
grant select on sm$ts_used to nk;
grant select on sm_$version to nk;
grant select on source_size to nk;
grant select on straddling_rs_objects to nk;
grant select on synonyms to nk;
grant select on syscatalog to nk;
grant select on syscatalog_ to nk;
grant select on sysfiles to nk;
grant select on syssegobj to nk;
grant select on sys_dba_segs to nk;
grant select on sys_objects to nk;
grant select on sys_user_segs to nk;
grant select on tab to nk;
grant select on table_privileges to nk;
grant select on tabquotas to nk;
grant select on tp$ to nk;
grant select on trusted_servers to nk;
grant select on ts_pitr_check to nk;
grant select on ts_pitr_info to nk;
grant select on ts_pitr_objects_to_be_dropped to nk;
grant select on user_all_tables to nk;
grant select on user_arguments to nk;
grant select on user_audit_object to nk;
grant select on user_audit_session to nk;
grant select on user_audit_statement to nk;
grant select on user_audit_trail to nk;
grant select on user_catalog to nk;
grant select on user_clusters to nk;
grant select on user_cluster_hash_expressions to nk;
grant select on user_clu_columns to nk;
grant select on user_coll_types to nk;
grant select on user_col_comments to nk;
grant select on user_col_privs to nk;
grant select on user_col_privs_made to nk;
grant select on user_col_privs_recd to nk;
grant select on user_constraints to nk;
grant select on user_cons_columns to nk;
grant select on user_db_links to nk;
grant select on user_dependencies to nk;
grant select on user_errors to nk;
grant select on user_extents to nk;
grant select on user_free_space to nk;
grant select on user_indexes to nk;
grant select on user_ind_columns to nk;
grant select on user_ind_partitions to nk;
grant select on user_jobs to nk;
grant select on user_libraries to nk;
grant select on user_lobs to nk;
grant select on user_method_params to nk;
grant select on user_method_results to nk;
grant select on user_nested_tables to nk;
grant select on user_objects to nk;
grant select on user_object_size to nk;
grant select on user_object_tables to nk;
grant select on user_obj_audit_opts to nk;
grant select on user_part_col_statistics to nk;
grant select on user_part_histograms to nk;
grant select on user_part_indexes to nk;
grant select on user_part_key_columns to nk;
grant select on user_part_tables to nk;
grant select on user_password_limits to nk;
grant select on user_queues to nk;
grant select on user_queue_tables to nk;
grant select on user_refresh to nk;
grant select on user_refresh_children to nk;
grant select on user_refs to nk;
grant select on user_registered_snapshots to nk;
grant select on user_resource_limits to nk;
grant select on user_role_privs to nk;
grant select on user_segments to nk;
grant select on user_sequences to nk;
grant select on user_snapshots to nk;
grant select on user_snapshot_logs to nk;
grant select on user_snapshot_refresh_times to nk;
grant select on user_source to nk;
grant select on user_synonyms to nk;
grant select on user_sys_privs to nk;
grant select on user_tables to nk;
grant select on user_tablespaces to nk;
grant select on user_tab_columns to nk;
grant select on user_tab_col_statistics to nk;
grant select on user_tab_comments to nk;
grant select on user_tab_histograms to nk;
grant select on user_tab_partitions to nk;
grant select on user_tab_privs to nk;
grant select on user_tab_privs_made to nk;
grant select on user_tab_privs_recd to nk;
grant select on user_triggers to nk;
grant select on user_trigger_cols to nk;
grant select on user_ts_quotas to nk;
grant select on user_types to nk;
grant select on user_type_attrs to nk;
grant select on user_type_methods to nk;
grant select on user_updatable_columns to nk;
grant select on user_users to nk;
grant select on user_views to nk;
grant select on v_$access to nk;
grant select on v_$active_instances to nk;
grant select on v_$aq to nk;
grant select on v_$aq1 to nk;
grant select on v_$archive to nk;
grant select on v_$archived_log to nk;
grant select on v_$archive_dest to nk;
grant select on v_$backup to nk;
grant select on v_$backup_corruption to nk;
grant select on v_$backup_datafile to nk;
grant select on v_$backup_device to nk;
grant select on v_$backup_piece to nk;
grant select on v_$backup_redolog to nk;
grant select on v_$backup_set to nk;
grant select on v_$bgprocess to nk;
grant select on v_$bh to nk;
grant select on v_$buffer_pool to nk;
grant select on v_$circuit to nk;
grant select on v_$class_ping to nk;
grant select on v_$compatibility to nk;
grant select on v_$compatseg to nk;
grant select on v_$controlfile to nk;
grant select on v_$controlfile_record_section to nk;
grant select on v_$copy_corruption to nk;
grant select on v_$current_bucket to nk;
grant select on v_$database to nk;
grant select on v_$datafile to nk;
grant select on v_$datafile_copy to nk;
grant select on v_$datafile_header to nk;
grant select on v_$dbfile to nk;
grant select on v_$dblink to nk;
grant select on v_$db_object_cache to nk;
grant select on v_$db_pipes to nk;
grant select on v_$deleted_object to nk;
grant select on v_$dispatcher to nk;
grant select on v_$dispatcher_rate to nk;
grant select on v_$dlm_convert_local to nk;
grant select on v_$dlm_convert_remote to nk;
grant select on v_$dlm_latch to nk;
grant select on v_$dlm_locks to nk;
grant select on v_$dlm_misc to nk;
grant select on v_$enabledprivs to nk;
grant select on v_$enqueue_lock to nk;
grant select on v_$event_name to nk;
grant select on v_$execution to nk;
grant select on v_$filestat to nk;
grant select on v_$file_ping to nk;
grant select on v_$fixed_table to nk;
grant select on v_$fixed_view_definition to nk;
grant select on v_$global_transaction to nk;
grant select on v_$indexed_fixed_column to nk;
grant select on v_$instance to nk;
grant select on v_$kccdi to nk;
grant select on v_$kccfe to nk;
grant select on v_$latch to nk;
grant select on v_$latchholder to nk;
grant select on v_$latchname to nk;
grant select on v_$latch_children to nk;
grant select on v_$latch_misses to nk;
grant select on v_$latch_parent to nk;
grant select on v_$librarycache to nk;
grant select on v_$license to nk;
grant select on v_$loadcstat to nk;
grant select on v_$loadpstat to nk;
grant select on v_$loadtstat to nk;
grant select on v_$lock to nk;
grant select on v_$locked_object to nk;
grant select on v_$locks_with_collisions to nk;
grant select on v_$lock_activity to nk;
grant select on v_$lock_element to nk;
grant select on v_$log to nk;
grant select on v_$logfile to nk;
grant select on v_$loghist to nk;
grant select on v_$log_history to nk;
grant select on v_$mls_parameters to nk;
grant select on v_$mts to nk;
grant select on v_$mystat to nk;
grant select on v_$nls_parameters to nk;
grant select on v_$nls_valid_values to nk;
grant select on v_$object_dependency to nk;
grant select on v_$offline_range to nk;
grant select on v_$open_cursor to nk;
grant select on v_$option to nk;
grant select on v_$parameter to nk;
grant select on v_$pq_sesstat to nk;
grant select on v_$pq_slave to nk;
grant select on v_$pq_sysstat to nk;
grant select on v_$pq_tqstat to nk;
grant select on v_$process to nk;
grant select on v_$pwfile_users to nk;
grant select on v_$queue to nk;
grant select on v_$recent_bucket to nk;
grant select on v_$recovery_file_status to nk;
grant select on v_$recovery_log to nk;
grant select on v_$recovery_progress to nk;
grant select on v_$recovery_status to nk;
grant select on v_$recover_file to nk;
grant select on v_$reqdist to nk;
grant select on v_$resource to nk;
grant select on v_$resource_limit to nk;
grant select on v_$rollname to nk;
grant select on v_$rollstat to nk;
grant select on v_$rowcache to nk;
grant select on v_$rowcache_parent to nk;
grant select on v_$rowcache_subordinate to nk;
grant select on v_$session to nk;
grant select on v_$session_connect_info to nk;
grant select on v_$session_cursor_cache to nk;
grant select on v_$session_event to nk;
grant select on v_$session_longops to nk;
grant select on v_$session_object_cache to nk;
grant select on v_$session_wait to nk;
grant select on v_$sesstat to nk;
grant select on v_$sess_io to nk;
grant select on v_$sga to nk;
grant select on v_$sgastat to nk;
grant select on v_$shared_pool_reserved to nk;
grant select on v_$shared_server to nk;
grant select on v_$sort_segment to nk;
grant select on v_$sort_usage to nk;
grant select on v_$sql to nk;
grant select on v_$sqlarea to nk;
grant select on v_$sqltext to nk;
grant select on v_$sqltext_with_newlines to nk;
grant select on v_$sql_bind_data to nk;
grant select on v_$sql_bind_metadata to nk;
grant select on v_$sql_cursor to nk;
grant select on v_$sql_shared_memory to nk;
grant select on v_$statname to nk;
grant select on v_$subcache to nk;
grant select on v_$sysstat to nk;
grant select on v_$system_cursor_cache to nk;
grant select on v_$system_event to nk;
grant select on v_$system_parameter to nk;
grant select on v_$tablespace to nk;
grant select on v_$thread to nk;
grant select on v_$timer to nk;
grant select on v_$transaction to nk;
grant select on v_$transaction_enqueue to nk;
grant select on v_$type_size to nk;
grant select on v_$version to nk;
grant select on v_$waitstat to nk;
grant select on v_$_lock to nk;

rem ----------------------------------------------------------------------
rem -- SYSTEM_PRIVILEGE_MAP
rem ----------------------------------------------------------------------
grant alter system to nk;
grant audit system to nk;
grant create session to nk;
grant alter session to nk;
grant restricted session to nk;
grant create tablespace to nk;
grant alter tablespace to nk;
grant manage tablespace to nk;
grant drop tablespace to nk;
grant unlimited tablespace to nk;
grant create user to nk;
grant become user to nk;
grant alter user to nk;
grant drop user to nk;
grant create rollback segment to nk;
grant alter rollback segment to nk;
grant drop rollback segment to nk;
grant create table to nk;
grant create any table to nk;
grant alter any table to nk;
grant backup any table to nk;
grant drop any table to nk;
grant lock any table to nk;
grant comment any table to nk;
grant select any table to nk;
grant insert any table to nk;
grant update any table to nk;
grant delete any table to nk;
grant create cluster to nk;
grant create any cluster to nk;
grant alter any cluster to nk;
grant drop any cluster to nk;
grant create any index to nk;
grant alter any index to nk;
grant drop any index to nk;
grant create synonym to nk;
grant create any synonym to nk;
grant drop any synonym to nk;
grant sysdba to nk;
grant sysoper to nk;
grant create public synonym to nk;
grant drop public synonym to nk;
grant create view to nk;
grant create any view to nk;
grant drop any view to nk;
grant create sequence to nk;
grant create any sequence to nk;
grant alter any sequence to nk;
grant drop any sequence to nk;
grant select any sequence to nk;
grant create database link to nk;
grant create public database link to nk;
grant drop public database link to nk;
grant create role to nk;
grant drop any role to nk;
grant grant any role to nk;
grant alter any role to nk;
grant audit any to nk;
grant alter database to nk;
grant force transaction to nk;
grant force any transaction to nk;
grant create procedure to nk;
grant create any procedure to nk;
grant alter any procedure to nk;
grant drop any procedure to nk;
grant execute any procedure to nk;
grant create trigger to nk;
grant create any trigger to nk;
grant alter any trigger to nk;
grant drop any trigger to nk;
grant create profile to nk;
grant alter profile to nk;
grant drop profile to nk;
grant alter resource cost to nk;
grant analyze any to nk;
grant grant any privilege to nk;
grant create snapshot to nk;
grant create any snapshot to nk;
grant alter any snapshot to nk;
grant drop any snapshot to nk;
grant create any directory to nk;
grant drop any directory to nk;
grant create type to nk;
grant create any type to nk;
grant alter any type to nk;
grant drop any type to nk;
grant execute any type to nk;
grant create library to nk;
grant create any library to nk;
grant alter any library to nk;
grant drop any library to nk;
grant execute any library to nk;
grant writedown dblow to nk;
grant readup dbhigh to nk;
grant writeup dbhigh to nk;
grant writedown to nk;
grant readup to nk;
grant writeup to nk;