Archives of the TeradataForum

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

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

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