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