Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

SQL0551N in a strange circumstance

444 views
Skip to first unread message

madmoravian

unread,
Mar 18, 2009, 1:59:17 PM3/18/09
to
I'm connecting to a database, using Toad and dbVisualizer, with
username1. Some of the tables in the database allow me to run a
select on them, some of them don't.

But, a colleague sitting next to me, on his laptop, using Toad and the
same user name (username1) is able to run select on all tables. Even
the ones I can't.

Does anyone have any suggestions?

I know this is, almost assuredly, not a db2 problem I wasn't certain
where to start looking for an answer.

Ian

unread,
Mar 18, 2009, 5:53:41 PM3/18/09
to

It would be useful if you post any errors you get.

Sawan

unread,
Mar 19, 2009, 6:29:52 AM3/19/09
to


Just a guess,
Are there any Trusted Connections set ?
http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/topic/com.ibm.db2.luw.admin.sec.doc/doc/c0050514.html

Regards,
Sawan Gupta
IBM India Software labs

madmoravian

unread,
Mar 19, 2009, 8:27:28 AM3/19/09
to

Here it is.....

An error occurred while executing the database request for:
DB2/LINUXX8664
SQL09016
IBM DB2 JDBC Universal Driver Architecture
3.50.152

Short message:
DB2 SQL Error: SQLCODE=-551, SQLSTATE=42501,
SQLERRMC=RPTUSER;SELECT;INSTTXDW.TAKS_SOURCE_RECORDS_2009,
DRIVER=3.50.152

The command that caused the problem:
select * from "INSTTXDW"."TAKS_SOURCE_RECORDS_2009"

Long Message:
DB2 SQL Error: SQLCODE=-551, SQLSTATE=42501,
SQLERRMC=RPTUSER;SELECT;INSTTXDW.TAKS_SOURCE_RECORDS_2009,
DRIVER=3.50.152

Details:
Type: com.ibm.db2.jcc.b.nm
Error Code: -551
SQL State: 42501

1) Nested Exception:

Long Message:
DB2 SQL Error: SQLCODE=-727, SQLSTATE=56098,
SQLERRMC=2;-551;42501;RPTUSER|SELECT|
INSTTXDW.TAKS_SOURCE_RECORDS_2009, DRIVER=3.50.152

Details:
Type: com.ibm.db2.jcc.b.SqlException
Error Code: -727
SQL State: 56098

System Information:
Product: DbVisualizer Free 6.5.4
Build: #1362 (2009/02/05 20:09)
Java VM: Java HotSpot(TM) Client VM
Java Version: 1.6.0_11
Java Vendor: Sun Microsystems Inc.
OS Name: Windows XP
OS Arch: x86
OS Version: 5.1

tha...@gmail.com

unread,
Mar 19, 2009, 6:40:45 PM3/19/09
to

Looks to me that it's in fact using a user called "rptuser", which
does not have select privs to those tables...

/T

madmoravian

unread,
Mar 20, 2009, 8:58:23 AM3/20/09
to


True. But both my colleague and I are connecting with that user id.
He can see all of the data while I can just see some of it.

madmoravian

unread,
Mar 20, 2009, 9:00:43 AM3/20/09
to
On Mar 19, 5:40 pm, thal...@gmail.com wrote:

I put a dummy username (username1) in my first message, not the real
username (rptuser).

0 new messages