Updating views

  • Thread starter Thread starter R.D.CHETTY
  • Start date Start date
R

R.D.CHETTY

Hi

I have a table with abt 1000 records and 150 feilds in SQL
SERVER,2000. I have five users who should have read
pemissions on all the records and update permissions on
some records only(depending on the flag)

If i create 5 views and give full permissions users and
only read permissions on table, then link table to .mdb,
will they be able to insert data into table though they
dont have permission on table to do so.

How to go abt it

Thanks in advance

R.D.CHETTY
 
Back
Top