Archives of the TeradataForum

Message Posted: Fri, 12 Sep 2003 @ 23:42:23 GMT

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

There is no user ALL, but there is a row in DBC.Dbase where databaseid is '00000000'xb and databasename is 'ALL'.

There is no table ALL, but there is a row in DBC.TVM where TVMID is '000000000000'xb and tvmname is 'ALL'.

There is no column ALL, but there is a row in DBC.TVFields where fieldid is 0 and and fieldname is 'ALL'.

These rows are handy for making 'ALL' show up in views like DBC.AllRights. For instance, the tablename the AllRights view returns for rights granted at the database level is 'ALL'.

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