Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

In DB2 how to find owners for a particular table

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
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    Post subject: In DB2 how to find owners for a particular table
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

Site Director


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

PostPosted: Wed Dec 05, 2007 4:17 am    Post subject:
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    Post subject:
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    Post subject:
Reply with quote

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

Global Moderator


Joined: 14 Mar 2007
Posts: 10232
Location: italy

PostPosted: Wed Dec 05, 2007 10:16 pm    Post subject: Reply to: In DB2 how to find owners for a particular table
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    Post subject:
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    Post subject:
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    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Data replication from multiple Db2 ta... kishpra DB2 5 Mon Mar 27, 2017 9:58 pm
No new posts how to send just 10 rows in a CICS sc... Megha Gupta CICS 5 Thu Feb 23, 2017 6:57 pm
No new posts Join of more than one table dibyendumandal11111 DB2 6 Mon Feb 13, 2017 11:36 pm
No new posts find particular member name in PDS us... ravi243 CLIST & REXX 10 Mon Dec 19, 2016 6:44 pm
No new posts SQL query to run through list of valu... Ni3-db2 DB2 14 Wed Dec 14, 2016 9:52 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us