Re: Row Security

From: Pankul Verma (pankul@urbanwireless.com)
Date: 05/15/02


From: "Pankul Verma" <pankul@urbanwireless.com>
Date: Wed, 15 May 2002 14:20:15 -0400


trigger is a good way to do it ...
but make sure you stamp the user ids

"Graham Powell" <graham.powell@brammer.com> wrote in message
news:37bd01c1fc2c$704c1740$a5e62ecf@tkmsftngxa07...
> Is there any way to prevent users with delete permissions
> to a particular table from deleting each other's data? If
> both UserA and UserB can modify data in Table1, is there
> any way to limit them to modifying only records that they
> themselves have created?
>
> Thanks,
>
> Graham Powell