Difference between DB Name of SYSTABAUTH and SYSTABLE



IBM's flagship relational database management system

Difference between DB Name of SYSTABAUTH and SYSTABLE

Postby Surabhi » 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.
Surabhi
 
Posts: 49
Joined: Thu Sep 10, 2015 7:51 pm
Has thanked: 4 times
Been thanked: 0 time

Re: Difference between DB Name of SYSTABAUTH and SYSTABLE

Postby Akatsukami » Sun Dec 18, 2016 8:43 pm

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.
"You have sat too long for any good you have been doing lately ... Depart, I say; and let us have done with you. In the name of God, go!" -- what I say to a junior programmer at least once a day
User avatar
Akatsukami
Global moderator
 
Posts: 1058
Joined: Sat Oct 16, 2010 2:31 am
Location: Bloomington, IL
Has thanked: 6 times
Been thanked: 51 times

Re: Difference between DB Name of SYSTABAUTH and SYSTABLE

Postby Surabhi » Sun Dec 18, 2016 10:31 pm

Thank you
Surabhi
 
Posts: 49
Joined: Thu Sep 10, 2015 7:51 pm
Has thanked: 4 times
Been thanked: 0 time


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post