Can you trigger an automatic WHERE-clause on any statement on a table?

[Quoted] Hi all

[Quoted] [Quoted] We are currently in the process of migrating a previous single-user [Quoted] [Quoted] application to a multi-user application running on the web using Forms [Quoted] Server 6i on Oracle8i 8.1.6 on Windows NT. The multi-user application is [Quoted] supposed to be based on user rights specified in a user table, which [Quoted] contains information about, which modules of the application, the user is [Quoted] allowed to use.

The existing database schema will be changed to include a "user_id" tuple in [Quoted] each table, which contains user data. This tuple will reference the user [Quoted] [Quoted] table's primary key "user_id". This means, that either we have to change a [Quoted] [Quoted] lot of SQL statement throughout the program to include "WHERE <user [Quoted] data-table>.user_id = users.user_id" (the "users.user_id" is at login [Quoted] compared with "SELECT USER FROM DUAL", and if no rows returned, the user is [Quoted] denied application login).

[Quoted] [Quoted] Does anyone know, if it is possible to create a trigger or some other [Quoted] database mechanism, which you could use on the user data tables, which [Quoted] automatically appends the mentioned WHERE-clause, or do we have to re-code [Quoted] all the SQL statements in the application?

Any advice on this subject would be greatly appreciated!

Thanks in advance
Jacob

jacmads_at_hotmail.com Received on Sun Oct 08 2000 - 21:40:57 CEST