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
smartcobra
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: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
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.

By
Vamsi.
Previous Topic: avg( ) over (partition by )
Next Topic: cursor help
Goto Forum:
  


Current Time: Tue Dec 06 06:46:11 CST 2016

Total time taken to generate the page: 0.05716 seconds