more acces control needed ;-)

hi there,

is there a mecanism similar to the views who allow more acces control ?

exp: i want a user to update, delete a table only if table.column_x = 'something" and insert date to it;

in other word,
if i do : create view table_view as select * from table where table.column_x = 'something" ;

my user can NOT insert, update or delete data to the view , and then to my table ?

please, is this possible in general on the database theory ? Received on Fri Feb 16 2001 - 07:36:18 CST