Page 1 of 1

Difference between DB Name of SYSTABAUTH and SYSTABLE

PostPosted: Sat Dec 17, 2016 7:52 pm
by Surabhi
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.

Re: Difference between DB Name of SYSTABAUTH and SYSTABLE

PostPosted: Sun Dec 18, 2016 8:43 pm
by Akatsukami
This link is to the IBM documentation for DB2 11.0 SYSTABLE. This link is to the IBM documentation for DB2 11.0 SYTABAUTH. As you can see, they are very different, as expected since they have little to do with each other.

I agree with Mr. Prins' opinion; you ought to remove DB2 from your skillset, since it is evident that you know it at a very junior level, if at all.

Re: Difference between DB Name of SYSTABAUTH and SYSTABLE

PostPosted: Sun Dec 18, 2016 10:31 pm
by Surabhi
Thank you