Re: Record Level Security
From: John Bell (jrm_bell@hotmail.com)
Date: 12/30/02
- Next message: Sue Hoegemeier: "Re: Jobs step can't see database"
- Previous message: Pat Diminico: "Record Level Security"
- In reply to: Pat Diminico: "Record Level Security"
- Next in thread: Alvin Zhao[MSFT]: "RE: Record Level Security"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "John Bell" <jrm_bell@hotmail.com> Date: Mon, 30 Dec 2002 22:37:14 -0000
Hi
If you are on SQL2000 you may want to look at the methods describe in the
topic "Inline User-Defined Functions" in books online.
The USER_NAME function may also be of use.
John
"Pat Diminico" <pat@diminico.com> wrote in message
news:07ad01c2b051$bc676f10$89f82ecf@TK2MSFTNGXA01...
> Is there a way to restrict a user to only view thier data
> in a single table? Example : Users A and B have data in
> Table1. Table1 has a column labled User_ID. I would like
> to have User A only see data where the User_ID=A and the
> same process for User B.
>
> Thank you
- Next message: Sue Hoegemeier: "Re: Jobs step can't see database"
- Previous message: Pat Diminico: "Record Level Security"
- In reply to: Pat Diminico: "Record Level Security"
- Next in thread: Alvin Zhao[MSFT]: "RE: Record Level Security"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
