In DB2 how to find owners for a particular table

Thangaraju Ganesan · New User Joined: 29 Nov 2007 Posts: 3 Location: USA

Hi,

I try to add a bind plan to my DB2 program with some owner name, after the addition I got the sql code error -551. Explain for the above error is
�-551 auth-id DOES NOT HAVE THE PRIVILEGE TO PERFORM OPERATION operation ON OBJECT object-name �

From the above statement I understand that my owner (auth id) does not have access for the table which I have used in my program. My question is how to find the owner (auth id) which has the access for a particular table.

I believe some SYSIBM table might have the entry for the table, its owner and it's access type. Can anyone let me know what that table is?

dick scherrer · Posted: Wed Dec 05, 2007 4:17 am Post subject:

Hello Thangaraju Ganesan and welcome to the forums,

When you have a question, you should start a new topic rather than reply to some existing topic.

Your question has been split ito a new topic.

dbzTHEdinosauer · Posted: Wed Dec 05, 2007 12:27 pm Post subject:

there are two appendice in every db2 sql reference. one is a definition of each of the sysibm tables for the db2 version and the other contains examples of sql to be used on each sysibm table.

Thangaraju Ganesan · New User Joined: 29 Nov 2007 Posts: 3 Location: USA

Any other explanation

enrico-sorichetti

why don' t You speak with the dba's
if the table was built by a different user maybe it was an oversight,
or anyway there are some authorization conflicts, and the dba' s will
need to know about it to fix it

Navars · New User Joined: 31 Jan 2007 Posts: 2 Location: Hyderabad

Hi Thangaraju Ganesan,

Perform the following . Hope this info helps u

.

SELECT GRANTEE FROM SYSIBM.SYSTABAUTH
WHERE TTNAME = tablename
AND GRANTEETYPE <> 'P';

GRANTEE is the name of the column that contains authorization IDs for users of tables.

The clause GRANTEETYPE <> 'P' ensures that you retrieve the names only of users (not application plans or packages) that have authority to access the table.

Regards
Sravan

Thangaraju Ganesan · New User Joined: 29 Nov 2007 Posts: 3 Location: USA

Yes, you are correct. table SYSIBM.SYSTABAUTH will say the owner access for particular table.

Thanks
Thangaraju G