+1 on Selva's suggestion, and we can define the semantics of these GET commands as follows.
"get table" and "get user table": all user-defined tables minus the histogram ones; "get all tables": all user-defined tables, plus the histogram tables; "get system tables": all meta-data tables; Agree with Roberta on the role that the privileges play in this context. --Qifan ________________________________ From: Roberta Marton <[email protected]> Sent: Tuesday, June 19, 2018 10:06:10 AM To: [email protected] Subject: RE: [DISCUSS] Filter out SYSTEM object for various GET utilities We do only show objects that the current user has privileges on. So db__root would see everything while sql_user1 sees only tables that they have at least one privilege. Would this be sufficient? Of course authentication has to be enabled and the user cannot be granted the SHOW privilege. Roberta -----Original Message----- From: Selva Govindarajan [mailto:[email protected]] Sent: Tuesday, June 19, 2018 7:58 AM To: [email protected] Subject: RE: [DISCUSS] Filter out SYSTEM object for various GET utilities I believe " get all tables", " get user tables", "get system tables" commands are already available. But it seems to return the same information. I would think you might consider fixing these commands if possible. Selva -----Original Message---- From: Ming <[email protected]> Sent: Tuesday, June 19, 2018 1:54 AM To: [email protected] Subject: [DISCUSS] Filter out SYSTEM object for various GET utilities Hi, all, I have got some requirements from the support engineers of Trafodion, that wish to filter out those system objects when doing 'get tables', for example, those histogram tables, not showing them. I have created JIRA: https://issues.apache.org/jira/browse/TRAFODION-3113 What do all others think about this? Shall we need to do this? Or you have better ideas? I noticed there are various GET commands, and maybe we can show all object when it is DB__ROOT, but for normal user, just show normal objects. Or we should add some new command like 'get all tables' , 'get user tables' , 'get system tables' , for example? thanks, Ming
