Re: Row level secrity
From: Scott Urman <surman_at_oracle.com>
Date: 1995/06/20
Message-ID: <3s7d0k$iuk_at_inet-nntp-gw-1.us.oracle.com>#1/1
Date: 1995/06/20
Message-ID: <3s7d0k$iuk_at_inet-nntp-gw-1.us.oracle.com>#1/1
In article <3s5c6s$m07_at_antares.en.com>, whitney_at_en.com (Nancy C. Whitney) writes:
|>
|>
|> I would like to achieve row-level security on a per-user basis. I got a
|> quote for Trusted Oracle, but at $60,000 (for our site with the number of
|> user we have according to a sales rep at Oracle :-( ) I decided to see
|> what others are doing. Any ideas?
|>
|> Regards,
|>
|> Nancy
|>
Probably triggers would be your best bet. This can only be done for insert, update, and delete statements, though, and not select stmts. Check the value of the SQL function 'user', and if you don't like it, raise an application error. Received on Tue Jun 20 1995 - 00:00:00 CEST