Permission on View

[accessman2]

Hi,

I create the table "Personal Information", which list all the employees information, such as id num, name, age, department.......
Only me has full permission on this table.

I create the View, which select fields: name, age, department columns for my co-worker to read, update, and add new employee permission. I give out these permission to co-worker, but my worker doesn't work.

Actually, if my co-worker update info. via the View, do I need to give out same permission for the table except the View?

 

[pdx_man]

Don't mean to be short, but I answered this question for you a month ago ...

http://www.access-programmers.co.uk/forums/showthread.php?t=126317&highlight=view

 

[tehNellie]

You cannot edit/insert data in a view. It is just that, a view of the data.

In SQL server 2000 at least, you can update a table or insert new data into a table via a view. If it's any consolation that was my initial understanding of views until I accidentally "wrecked" a table updating data via a view, which I was sure I couldn't do.

Some indication as to the problem other than "it doesn't work" might be useful. What error message do you get when you try an insert/update/delete via the View? Does the View display all columns that require a value or is there a Trigger to cover that possibility? How is your security configured at the moment.

Permissions for the view can be different to the permissions on the table. You can deny direct access to the table while still allowing permission to the view.