with sql server it is easy. One possible way:
- start enterprise manager
- open your database
- go into tables/views
- right click on a table/view
- select all tasks -> manage grants
(i don't know if this is the name, i have only
the german version)
in this window you can select your view/table
in the combobox, you see all users with their
rights and on the bottom you find the button
'columns' where you can set the rights for
a specific user on a specific row.
hth,
Helmut
"Richard Holliingsworth" <wi*********************@boeing.com> schrieb im
Newsbeitrag news:HJ********@news.boeing.com...
Hello:
I have an Access 2K form I built from a SQL Server 7.0 view. I want to
lock certain fields in the database from users so they can see them on
the views and forms, but NOT be able to edit them.
I've looked in BOL, MS SQL Server web page and SQL Server 7.0 books and
could not find how to do this.
Any advise will be greatly appreciated.
Thanks,
Richard