0

trigger usually is on delete, update, insert. It means update data. I want to a trigger for access data. for example, when applying select on a table, then a trigger can be fired.

Is it possible to create a trigger on select for sybase ase 12.5?

KentZhou
  • 24,805
  • 41
  • 134
  • 200
  • The only way to look at something on access would be to use database auditing with ASE Security and the sybsecurity database. The downside to using it, is the performance hit. http://infocenter.sybase.com/archive/index.jsp?topic=/com.sybase.dc31654_31644_1250/html/sag/X23329.htm – Mike Gardner Jun 25 '14 at 20:24
  • no select triggers in sybase ase. you probably want to use view where you can show user what they need to see and nothing else. – Meet Jun 26 '14 at 10:21

1 Answers1

1

This is trigger's statement from documentation:

create trigger [owner .]trigger_name
    on [owner .]table_name
    for {insert , update , delete} 
    as SQL_statements

as you can see, there is no option for select. So it's not possible.

Robert
  • 25,425
  • 8
  • 67
  • 81