◐ Shell
clean mode source ↗

Cleanup grants of internal objects & tables by jgebal · Pull Request #954 · utPLSQL/utPLSQL

added 4 commits

June 22, 2019 17:22
Removed grants:
- execute on ut_annotations
- execute on ut_annotation
- execute on ut_annotated_object
- execute on ut_annotated_objects
- select on ut_annotation_cache
- select on ut_annotation_cache_info
- execute ut_annotation_cache_manager
- execute ut_annotation_parser

Reorganized code to accommodate for grants removal.
Wrapped `sys.dbms_assert.qualified_sql_name` to support NULL values.
Replaced calls to `dbms_crypto.hash` with `ut_utils.get_hash` - default `SHA1`
- `ut_coverage`
- `ut_coverage_options`
- `ut_coverage_helper`
- ut_output_reporter_base
- ut_coverage_reporter_base
- ut_console_reporter_base
- ut_output_data_row
- ut_output_data_rows
- ut_output_table_buffer
- ut_output_clob_table_buffer

@jgebal jgebal changed the title Cleanup some grants to internal objects & tables [WIP] Cleanup grants to internal objects & tables

Jun 24, 2019
…LIC and private access to the framework.

Resolves: #957
…shed and transaction is committed.

lwasylow

- grant select, insert, update, delete on ut_compound_data_tmp
- grant select, insert, update, delete on ut_compound_data_diff_tmp
- changed `dbmspcc_...` tables to be global temporary
- added cleanup of session level global temp tables after run

@jgebal jgebal changed the title [WIP] Cleanup grants to internal objects & tables Cleanup grants of internal objects & tables

Jun 28, 2019

@jgebal jgebal deleted the feature/grants_cleanup branch

June 28, 2019 16:46