trafodion-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Roberta Marton <>
Subject RE: [DISCUSS] Filter out SYSTEM object for various GET utilities
Date Tue, 19 Jun 2018 15:06:10 GMT
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.


-----Original Message-----
From: Selva Govindarajan [] 
Sent: Tuesday, June 19, 2018 7:58 AM
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.


-----Original Message----
From: Ming <> 
Sent: Tuesday, June 19, 2018 1:54 AM
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:


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?




View raw message