Difference between DB Name of SYSTABAUTH and SYSTABLE
Posted: Sat Dec 17, 2016 7:52 pm
Hi all,
Is there any difference between DB Name of SYSTABAUTH and SYSTABLE
SYSIBM.SYSTABLE
DBNAME --
VARCHAR(24)
NOT NULL
For a table, or a view of tables, the name of the database that contains the table space that is named in TSNAME. For a created temporary table, an alias, or a view of a view, the value is DSNDB06.
SYSIBM.SYSTABAUTH
DBNAME --
VARCHAR(24)
NOT NULL
If the privileges were received from a user with DBADM, DBCTRL, or DBMAINT authority, DBNAME is the name of the database on which the GRANTOR has that authority. Otherwise, DBNAME is blank.
Is there any difference between DB Name of SYSTABAUTH and SYSTABLE
SYSIBM.SYSTABLE
DBNAME --
VARCHAR(24)
NOT NULL
For a table, or a view of tables, the name of the database that contains the table space that is named in TSNAME. For a created temporary table, an alias, or a view of a view, the value is DSNDB06.
SYSIBM.SYSTABAUTH
DBNAME --
VARCHAR(24)
NOT NULL
If the privileges were received from a user with DBADM, DBCTRL, or DBMAINT authority, DBNAME is the name of the database on which the GRANTOR has that authority. Otherwise, DBNAME is blank.