![](//teradataforum.com/imgs/ptdfw1.gif) |
![](//teradataforum.com/imgs/ptdfw2.gif) |
Archives of the TeradataForum
Message Posted: Wed, 04 Aug 2004 @ 13:42:07 GMT
Subj: | | Re: User rights on a table(s) |
|
From: | | Dieter Noeth |
Anomy Anom wrote:
| Thanks for your input and that does part of what I want but this methodology does not indicate the implicit rights held by users. For
instance, I have access rights to read and update a database, but the methodology of reading the AllRights view does not indicate this. | |
Just modify the Where-condition to include the "ALL" table, this indicates rights on database level:
where databasename = 'xxxxx' and tablename in ('yyyyyl', 'all')
Dieter
| |