Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 62 Insurance
- 536K On-Premises Infrastructure
- 138.2K Analytics Software
- 38.6K Application Development Software
- 5.7K Cloud Platform
- 109.4K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.2K Integration
- 41.5K Security Software
add READ ANY DICTIONARY privilege

Sven W.
Member Posts: 10,535 Gold Crown
Some time ago we got the new READ privilege.
SELECT has the disadvantage to allow LOCKs on the target table. Either via LOCK command or via "select for update...". This can be a potential security issue and therefore the READ privilege was introduced.
Note that there is also the READ ANY TABLE priv.
However it is not possible to give READ ANY DICTIONARY instead of SELECT ANY DICTIONARY.
Suggestion is to implement this.