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?

Report message to a moderator

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: 2112
Registered: October 2003
Location: Cincinnati, OH
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.

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Dec 05 18:42:21 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.