The user was not specifically granted access to the table. However, the
user is in a group that does have access to the table. Prior to moving
the database to another server (which was done by a database backup and
restore) the user was able to delete rows from the table.

Dan Luchinski
Database Administrator
ASPCA Knowledge Management Center
University of Illinois Allied Agency


"PALLIKARA KUTTIADAN S "
<db2udbdba-ezmlmshield-x78570052.[Email address protected] wrote on
06/29/2007 03:31:08 PM:

>
> SQLSTATE 42501: The authorization ID does not have the privilege to
> perform
> the specified operation on the identified object.
>
> Check whether you have required privelege tto perform the operation
>
> -----Original Message-----
> From: DanLuchinski
> [mailto:db2udbdba-ezmlmshield-x39658144.[Email address protected]
> Sent: Friday, June 29, 2007 4:07 PM
> To: LazyDBA Discussion
> Subject: SQL0551N SQLSTATE 42501
>
> Gurus,
>
> We recently moved a DB2 v9.1 FP2 database from a Windows 2000 server to
> a Windows 2003 server. A user is trying to delete a row from a table.
> The user does not have access to the table, but is part of a group that
> does.
> Anyone know why we are getting...
>
> 42501(-551)[IBM][CLI Driver][DB2/NT] SQL0551N "USERXX" does not have
> the privilege to perform operation "DELETE" on object "MYSCHEM.MYTABLE".
>
> SQLSTATE=42501
> (0.06 secs)
>
> Someone mentioned that it might have something to do with Windows 2003.
>
> Any help would be greatly appreciated.
>
> Thanks,
>
> Dan Luchinski
> Database Administrator
> ASPCA Knowledge Management Center
> University of Illinois Allied Agency
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
> dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
> - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
> - - - - - - - - - -
>
> This message is intended only for the personal and confidential use
> of the designated recipient(s) named above. If you are not the
> intended recipient of this message you are hereby notified that any
> review, dissemination, distribution or copying of this message is
> strictly prohibited. This communication is for information purposes
> only and should not be regarded as an offer to sell or as a
> solicitation of an offer to buy any financial product, an official
> confirmation of any transaction, or as an official statement of
> Lehman Brothers. Email transmission cannot be guaranteed to be
> secure or error-free. Therefore, we do not represent that this
> information is complete or accurate and it should not be relied upon
> as such. All information is subject to change without notice.
>
> --------
> IRS Circular 230 Disclosure:
> Please be advised that any discussion of U.S. tax matters contained
> within this communication (including any attachments) is not
> intended or written to be used and cannot be used for the purpose of
> (i) avoiding U.S. tax related penalties or (ii) promoting, marketing
> or recommending to another party any transaction or matter addressed
herein.
>
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>

DB2 & UDB email list listserv db2-l LazyDBA home page