Forum Stats

  • 3,824,847 Users
  • 2,260,430 Discussions
  • 7,896,330 Comments

Discussions

to introduce a separate privilege to create PRIVATE TEMPORARY TABLE rather than requiring CREATE TAB

User_PT223
User_PT223 Member Posts: 9 Blue Ribbon
edited Dec 4, 2019 6:11AM in Database Ideas - Ideas

For many different reasons in production systems we might not want to give end users the privilege to create conventional tables during normal operating hours - it is how like major part of all the systems work in real life.

Starting from 18c a new feature arrived - PRIVATE TEMPORARY TABLE. What we might want to is to give users to create only such private temp tables (for purposes they're designed for) - thus the privilege should be separate.

A real life example: system with a handful of object owners and thousands of end users which have only select, execute and dml privs on those tables. Some users might want to build up reports with complex PL/SQL logic and interim materialization to their private tables, but in order to do that they must have privilege CREATE TABLE which allows them to create plain tables, littering dictionary and consuming normal tablespaces

User_PT223GregVWilliam RobertsonBPeaslandDBAMike KutzberxDirk.NachbarAbhijit GourEmad Al-MousaLothar FlatzSven W.User_JUMFQ
12 votes

Active · Last Updated