Re: [Q] Conditional Grant ?

Lin FuXiong wrote:
>
> Dear netters:
>
> Is it possible for ORACLE to do "run time grant" ( row level grant ?) ?
>

  You can use the view to achieve your purpose. The definition of view may be
CREATE VIEW view_name AS SELECT * FROM base_table WHERE column = 1 WITH CHECK OPTION   Related Topics: Privileges and Roles, View

-- 
Name        : Lun Wing San
Title       : Oracle developer of the Hong Kong Productivity Council
              System Administrator and Oracle DBA of the Quick Response
Center
Email Addr. : sunny_at_hkpc.org
Telephone   : 852-2788-5841