Bug 6623

Summary: sys.rejects table need improvements
Product: SQL Reporter: Ying Zhang <y.zhang>
Component: allAssignee: SQL devs <bugs-sql>
Status: NEW ---    
Severity: enhancement    
Priority: Normal    
Version: 11.29.3 (Mar2018)   
Hardware: All   
OS: All   

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