Re: GRANT access rights on rows

On 1/4/06 5:56 PM, "Jaromír Kamler" <kamler(at)centrum(dot)cz> wrote:

> Hallo,
> I need GRANT some privilegies to one row. I know, that it si possible to do
> that for columns, but I do not know how do it for rows. Any ideas?
>
> Thanks for your advices.

Make a view that contains only the rows that you want to allow access to.
Then, grant access to that view.

Create view as select * from mytable where mytable.id=1;

Hope that helps.

Sean