Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 28 Jun 2013 @ 18:37:15 GMT


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


Subj:   Re: Only Directly Granted Rights Displayed in SQL Administrator 13.10.0.03
 
From:   Dave Wellman

Hi Michael,

I've had a quick look at the sql for Administrator 14.0 and it doesn't look like it does anything clever with accessrights and roles.

I recently posted a macro called "alluserrightsv" which lists all of the accessrights granted to a user, whether they be direct or via roles. That is on the forum attachments library. It should be fairly easy to adapt that macro to report on all accessrights held on a named database, this would at least give you a solution until such time as Administrator is changed/fixed to give you what you want.

- I've got this suggested change to my macro on my "list of things to do", but it's not at the top yet.


Cheers,

Dave

Ward Analytics Ltd - Information in motion (www.ward-analytics.com)



     
  <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: 23 Jun 2019