| Expertise needed on triggers [message #369961] |
Mon, 20 November 2000 20:50  |
Ziozio
Messages: 1
Registered: November 2000
|
Junior Member |
|
|
|
I facing this scenario. I have a table in Oracle8i that has some columns encrypted. I was looking at creating a trigger that can do native decryption in the output generated when a particular user "select" from this table. However, trigger doesn't accept "select" clause. Anyone has any idea or alternatives on how to implement this cleanly?
|
|
|
|
| Re: Expertise needed on triggers [message #369963 is a reply to message #369961] |
Tue, 21 November 2000 02:23  |
Tarun Chhichhia
Messages: 6
Registered: November 2000
|
Junior Member |
|
|
How about using views ? and getting the user to select from the views. within the view you can call a function that decrypts the col. as part of the view.
E.g below
original table
tab1 :
col1 --> encrypted
create view vtab1 as
(select col1,
decrypt_col(col1) col2); -- decrypting the --column values
let the user access the view vtab1, and they can
see col1, and col2 being the decrpted column only during the select time.
I hope this helps
Tarun
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
