Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 22 Apr 2005 @ 21:33:34 GMT


     
  <Prev Next>  
<<First
<Prev
Next>
Last>>
 


Subj:   V2R5 query to return tables for which user has permissions, given the database name.
 
From:   Anomy Anom

<-- 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?


Thanks



     
  <Prev Next>  
<<First
<Prev
Next>
Last>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016