Bug 6623 - sys.rejects table need improvements
Summary: sys.rejects table need improvements
Status: NEW
Alias: None
Product: SQL
Classification: Unclassified
Component: all (show other bugs)
Version: 11.29.3 (Mar2018)
Hardware: All All
: Normal enhancement
Assignee: SQL devs
Depends on:
Reported: 2018-07-11 13:59 CEST by Ying Zhang
Modified: 2018-07-11 13:59 CEST (History)
0 users


Note You need to log in before you can comment on or make changes to this bug.
Description Ying Zhang cwiconfidential 2018-07-11 13:59:28 CEST
User-Agent:       Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_5) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/11.1.1 Safari/605.1.15
Build Identifier: 

The current implementation of the sys.rejects table needs some improvements to be easier usable for normal users (i.e. not db admin):
1) A user with the COPY INTO global privilege should automatically have all privileges on sys.rejects. Currently, an explicit "grant select on sys.rejects to <my-user>;" is needed.

2) The "rejects" table should be moved from the "sys" schema to the "tmp" schema.

Reproducible: Always