Home » SQL & PL/SQL » SQL & PL/SQL » could trigger achieve the function?
could trigger achieve the function? [message #198780] Wed, 18 October 2006 08:49 Go to next message
Messages: 3
Registered: October 2006
Junior Member
I want to write a trigger to achieve this function that somebody can select,delete,update on a table but cann't select the special column of the table. is it possible?
Re: could trigger achieve the function? [message #198782 is a reply to message #198780] Wed, 18 October 2006 08:56 Go to previous message
vamsi kasina
Messages: 2108
Registered: October 2003
Location: Hyderabad, India
Senior Member
Seems you can create a view on the table by not selecting that particular column.
And do the DML's on the view instead of the table.

Previous Topic: Grouping Question
Next Topic: ORA-00937Group by / avg problem
Goto Forum:

Current Time: Mon Aug 21 10:59:10 CDT 2017

Total time taken to generate the page: 0.05361 seconds