can not delete record

[babeo]

Hi

I log in as 'sa' and I want to delete some records of TableA, but get error message of "Only the author of this record can delete it. Trasaction roll back"

What and why can this happen? Strangerly I am able to delete some records on the previously day!

Any discussion is appreciate.
Thanks

 

[JMCraig]

Sounds like someone (the table's owner?) put a trigger on the table in question (perhaps because they were unhappy with your having deleted records the previous day ;~) ). At least that's the only way I know you'd get an error like that.

If the owner of the table had revoked delete permission for 'dbo'--that's 'SA' in the DB in question, then you'd get a different message ('delete permission denied ...').

The trigger must be written with a check for the specific user_id() of the owner of the table (presumably with a hard-coded value or set of values that the author of the trigger thinks is/are valid).

HTH,

J M Craig
Alpha-G Consulting, LLC
nsjmcraig@netscape.net

 

[babeo]

Oh my !

If I am in front of you right now, I will bow you and call you "Master".

Your analysis is so right. Yeah, someone has change (rem out) the trigger the other day so that I "accident" to be able to delete a record, after that he/she sets back to check only userid() can delete his/her records only, even sa id can not delete records either.

Thanks for your response.

 

[JMCraig]

Sorry it took so long to get you the answer!


Cheers,

John
nsjmcraig@netscape.net