IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

In DB2 how to find owners for a particular table


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Thangaraju Ganesan

New User


Joined: 29 Nov 2007
Posts: 3
Location: USA

PostPosted: Wed Dec 05, 2007 3:49 am
Reply with quote

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?
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Wed Dec 05, 2007 4:17 am
Reply with quote

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.
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Wed Dec 05, 2007 12:27 pm
Reply with quote

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.
Back to top
View user's profile Send private message
Thangaraju Ganesan

New User


Joined: 29 Nov 2007
Posts: 3
Location: USA

PostPosted: Wed Dec 05, 2007 10:11 pm
Reply with quote

Any other explanation
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10872
Location: italy

PostPosted: Wed Dec 05, 2007 10:16 pm
Reply with quote

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
Back to top
View user's profile Send private message
Navars

New User


Joined: 31 Jan 2007
Posts: 2
Location: Hyderabad

PostPosted: Thu Dec 06, 2007 1:03 am
Reply with quote

Hi Thangaraju Ganesan,

Perform the following . Hope this info helps u icon_smile.gif .

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
Back to top
View user's profile Send private message
Thangaraju Ganesan

New User


Joined: 29 Nov 2007
Posts: 3
Location: USA

PostPosted: Fri May 16, 2008 8:57 pm
Reply with quote

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

Thanks
Thangaraju G
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Load new table with Old unload - DB2 DB2 6
No new posts Pulling a fixed number of records fro... DB2 2
No new posts To find whether record count are true... DFSORT/ICETOOL 6
No new posts Multiple table unload using INZUTILB DB2 2
No new posts Check data with Exception Table DB2 0
Search our Forums:

Back to Top