Archives of the TeradataForum
Message Posted: Fri, 22 Apr 2005 @ 21:33:34 GMT
<-- Anonymously Posted: Friday, April 22, 2005 17:26 -->
We are on V2R5. We have users who have been granted access to tables in databases other than their default via ROLES. Our application is trying to show a list of tables for which a user has access by using a query. The user will be executing the query, and will provide the database name.
Dbc.tablesX does not seem to have this information since the permssion was granted using roles (It seems to be fixed in V2R6). Modifying dbc.tablesX is not an option. We could possibly get this information from dbc.tables by adding a where clause to filter the database (it is OK to get additional table names in the database for which the user was not given access).
My question is:
(A) Given a database name and a userid, is there a query that will return all the tables for which a user has permissions (including those granted via roles).
(B) Using dbc.tables seems to be not so bad a solution for what we want, but do most installations have dbc.tables locked down, giving users permissions only to dbc.tablesX?
(c) Are there any issue with going against dbc.tablesX Vs dbc.tables other than retrieiving more rows, and being able to see tables belonging to other users?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|