Re: Granting access to rows in a table

Vaclav Kolar wrote:
>
> Hello !
>
> I'm using SQL server Interbase and I will use SQL servers Informix, MS SQL,
> Oracle and Sybase.
> And my questions:
> 1. How can I grant user access to a table, to columns in a table and to rows
> in a table?

In Interbase:
table: grant all/select/insert/update/delete on table to user columns: grant all/select/insert/update/delete (column1, column2) on table to user
rows: Here you have to 1)make a stored procedure and grant that stored procedure rights to the table and 2)then grant users rights to execute that stored procedure:
1) grant all/select/insert/update/delete on table to procedure xxxxx 2) grant execute on procedure xxxxx to user.

This all can be found in Interbase programmer's manual, so I'm not sure this is what you asked.

Heikki
Heikki.Ratinen_at_Tamfelt.fi Received on Wed Sep 10 1997 - 00:00:00 CDT