Re: Row Security
From: Pankul Verma (pankul@urbanwireless.com)
Date: 05/15/02
- Next message: David SheafferMS: "RE: End User Security Administrator for a Intranet Application"
- Previous message: oj: "Re: SQL Server in a Network"
- In reply to: Graham Powell: "Row Security"
- Next in thread: Graham Powell: "Re: Row Security"
- Reply: Graham Powell: "Re: Row Security"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
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
- Next message: David SheafferMS: "RE: End User Security Administrator for a Intranet Application"
- Previous message: oj: "Re: SQL Server in a Network"
- In reply to: Graham Powell: "Row Security"
- Next in thread: Graham Powell: "Re: Row Security"
- Reply: Graham Powell: "Re: Row Security"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]