[Q] Conditional Grant ?
From: Lin FuXiong <gis81566_at_cis.nctu.edu.tw>
Date: 1996/11/08
Message-ID: <55umhc$83j_at_netnews.nctu.edu.tw>#1/1
Date: 1996/11/08
Message-ID: <55umhc$83j_at_netnews.nctu.edu.tw>#1/1
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 LinReceived on Fri Nov 08 1996 - 00:00:00 CET