Archives of the TeradataForum
Message Posted: Fri, 28 Jun 2013 @ 18:37:15 GMT
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)
|Copyright 2016 - All Rights Reserved|
|Last Modified: 24 Jul 2020|