If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

I presume, you use alter table
-551 = missing authority
look at alter command in infocenter and see for needed authorities

Best Regards, Guy Przytula
Database Software Consultant
Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
Information Server Datastage Certifiedhttp://www.infocura.be

Best Regards, Guy Przytula
Database Software Consultant
Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
Information Server Datastage Certifiedhttp://www.infocura.be

Best Regards, Guy Przytula
Database Software Consultant
Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
Information Server Datastage Certifiedhttp://www.infocura.be

it complains about lack of SELECT privilege on TNAME for user BFEPRE1.
1. Is this a table or view object in the message "BFEPRE1|SELECT|TNAME"?
2. Are there "tname" in the ALTER statement and "TNAME" in the message above the same objects?
3. IF TNAME is a view, then what is the result of:

Code:

select count(1)
from syscat.tabauth
where tabschema='SCHEMA_PART_OF_TNAME' and tabname='TABLE_PART_OF_TNAME'
and grantee='BFEPRE1' and granteetype='U'

The SYSADM privilege fro BFEPRE1 is granted via a group, which would not be effective in static context. You'd need to grant the required privileges to the user directly, or log in as another user that has these privileges.

Hi,
tname is a table.
here I dont understand why BFEPRE1 came into picture.
I took the db2look for My table . here I got some information about
BFEPRE1 .
SET CURRENT SCHEMA = "MYSCHEMA";
SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","SYSIBMADM","BFEPR E1";

do not jump around - focus first on the original problem
have you tested the comment from Nick : You'd need to grant the required privileges to the user directly, or log in as another user that has these privileges.

Best Regards, Guy Przytula
Database Software Consultant
Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
Information Server Datastage Certifiedhttp://www.infocura.be

Probably there are some invalid objects dependent on this table.
Like triggers, routines, views. These objects might be created by user BFEPRE1.
DB2 tries to revalidate implicitly such object, and since user BFEPRE1 doesn't have SELECT privilege on table TNAME at the moment, the "alter" operation fails.
To investigate the problem you may analyze all these invalid dependent objects or just run "GRANT SELECT ON TABLE TNAME TO USER BFEPRE1" and try to alter this table column again.