Re: [Q] Conditional Grant ?

Lin FuXiong wrote:
>
> Dear netters:
>
> Is it possible for ORACLE to do "run time grant" ( row level grant ?) ?
>
> For example:
> table : tb1
> related column: id
> I want let "user1" manipulate those data in tb1 with tb1.id='1'.
>
> I guess the statement would look like:
>
> grant select, insert, update, delete on tb1 to user1 WHERE id='1';
>
> How can I do it ? ( I don't have ORACLE SQL SYNTAX REFERENCE at hand.)
> Any response to answer the question is appreciated.
> ---
> Fu-Xiong Lin
how about:
create vw1 as select * from tb1 where id = '1'; grant select on vw1 to user1;

Why not post this question to

	comp.databses.oracle.misc or
	comp.databses.oracle.server

--
Gert Rijs
mailto:gem_at_wirehub.net    (at home)
mailto:gert.rijs_at_corp.ah.nl (at work)