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



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: 24 Jul 2020