Thanks Roberta, that reminds me. Let me test with Security 'ON'. Probably it is already sufficient...
Ming -----Original Message----- From: Roberta Marton <[email protected]> Sent: Tuesday, June 19, 2018 11:06 PM 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
