Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 28 Jun 2013 @ 17:10:07 GMT

  <Prev Next>  
Next> Last>>  

Subj:   Only Directly Granted Rights Displayed in SQL Administrator
From:   Duchene, Michael

SQL Administrator ( when one right-clicks on a database name from the database tree and chooses "Rights on DB/User", only the rights that were granted directly to others are displayed - but rights granted via roles (i.e.: indirectly) are not shown.

Would like to see one of two things:

- The inclusion of rights granted via roles in this "Rights on DB/User" result set

- A separate menu selection that would amalgamate both the rights that were granted directly as well as those that were granted via roles

It is understood that a union of two queries would have to be done in order to up with an "amalgamated" result of rights "directly" granted and rights granted via roles. However, this (at least to me) does seem to be a missing "core functionality".

My frustration with this most recently came about when someone asked me the seemingly simple "Tell me all of the user IDs that have rights against my database" question. When I used the "Rights on DB/User", I didn't see any of the users that I knew had rights on the database in question. At that point I realized that all of the users I knew had rights were (properly) granted rights via roles - but there was no easy way to see such an "amalgamated" result set.

Does anyone know if this issue has been addressed in a more current version of SQL Administrator?

Michael Duchene
Ford Motor Company

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