Archives of the TeradataForum
Message Posted: Wed, 28 Aug 2002 @ 13:22:30 GMT
| Subj: | | Grant to ALL user |
| |
| From: | | Geoffrey Rommel |
Suppose you grant access on some database or object to ALL user_name. This means that it is granted to that user/database and also every
database owned by that user now and in the future. A row is added to DBC.AccessRights in which the AllnessFlag is 'Y'.
Now suppose you wish to leave the existing rights intact but make sure that that access is not granted in the future to any user under
the top-level user_name -- in other words, you wish to leave the row in AccessRights but set AllnessFlag to 'N'. Apparently this is not
possible. The manual says, "ALL user_name specifies that the privileges are to be ... revoked from the named database or user, and every
database or user owned by that database or user now and in the future."
Shouldn't it be possible to do this?
--wgr
| 
