Archives of the TeradataForum
Message Posted: Mon, 21 Jul 2003 @ 22:14:45 GMT
I try to change the DBC password using the Teradata Administrator (Modify User) which produces this statement
MODIFY USER "DBC" AS
But I get the error: "The user does not have DROP USER access to database DBC"
So then I use the "Tools-->Grant/Revoke-->ObjectRights" GUI:
GRANT DROP USER ON "DBC" TO "DBC"
..but I get the error "The user does not have DROP USER WITH GRANT OPTION access to database DBC"
I thought DBC has every right in the DB being the highest in the hierarchy so I am perplexed as to why I need 'DROP USER' permission for DBC, and also, I need to find a way to change the DBC password.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|