[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


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
Received on Fri Nov 08 1996 - 00:00:00 CET

Original text of this message