View previous topic :: View next topic
|
Author |
Message |
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? |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
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 |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
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 |
|
|
Thangaraju Ganesan
New User
Joined: 29 Nov 2007 Posts: 3 Location: USA
|
|
|
|
Any other explanation |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10872 Location: italy
|
|
|
|
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 |
|
|
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 |
|
Back to top |
|
|
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 |
|
Back to top |
|
|
|