Archives of the TeradataForum
Message Posted: Fri, 22 Mar 2002 @ 16:58:34 GMT
Table DBC.AccessRights contains a column called CreateUID, which is different from the GrantorID and sometimes null. I am unable to divine what this column might be. I have thought of these hypotheses, all of which I have ruled out by querying the data dictionary:
- It's the creator of the User.
- It's the creator of the TVM.
- It's the creator of the Database.
We are on V2R.04.01.00.10. In previous releases, the Data Dictionary Reference said nothing about this column; now, for column DBC.AllRights.CreatorName, it says, "Returns the name of the user who created the database, table, or the name of the user's creator." This doesn't seem to be correct.
In short, I am stumped. Any ideas?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|