Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
| Dev |
|
| QA |
|
| Priority | Low |
| Complexity | Unknown |
| Component | Q Analyzer - Permissions |
| Version | 13.0 |
Currently, ( 13.0.0 and 14.0.0 ), we allow scripting of Materialized Views for Oracle, but we do not script permissions for materialized views.
Consider scripting permissions of Materialized Views.
See attached
added grant/revoke scripting options to oracle mat views. needs testing
when I attempt the Grant or Revoke from the context menus, nothing appears in the query analyzer.
I don't see any errors in the logs, but I do see these in the SQL Log.
when I attempt the Grant or Revoke from the context menus, nothing appears in the query analyzer.
I don't see any errors in the logs, but I do see these in the SQL Log.
I didn't test this appropriately. It works.
I didn't test this appropriately. It works.
Mat View > Create doesn't respect the "File > Option > General > Scripting > SCRIPT Grant on CREATE" option.
Mat View > Create doesn't respect the "File > Option > General > Scripting > SCRIPT Grant on CREATE" option.
code added to handle permissions scripting when option "script permissions on create" is set to true for oracle mat views.
code added to handle permissions scripting when option "script permissions on create" is set to true for oracle mat views.
the "File > Option > General > Scripting > SCRIPT Grant on CREATE" option now gets the respect it deserves.
the "File > Option > General > Scripting > SCRIPT Grant on CREATE" option now gets the respect it deserves.
Issue #9584 |
| Closed |
| Fixed |
| Resolved |
Completion |
| No due date |
| Fixed Build v13.0.3-9 |
| No time estimate |
added grant/revoke scripting options to oracle mat views. needs testing