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
