Archives of the TeradataForum

Message Posted: Fri, 22 Mar 2002 @ 16:58:34 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

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?

--wgr=

	<Prev	Next>		<<First	<Prev	Next>	Last>>