Archives of the TeradataForum
Message Posted: Wed, 28 Aug 2002 @ 13:22:30 GMT
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?
|Copyright 2016 - All Rights Reserved
|Last Modified: 15 Jun 2023