Re: How to "catch" SELECT

Dussan Pirc wrote:

> I want to restrict some ROWS from some users - I wish that some users
> can't select all rows.... And I want to be implemented somewhere in
> server not in application...

  You can create a view that is constructed by selecting a particular set of rows that the users to select.

  Related Topics: Audit, Privilege and Role, 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