Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 SQL Server Security

Author  Topic 

sharonchapman
Starting Member

35 Posts

Posted - 2001-08-23 : 13:08:36
I'm using SQL Server 7.0 with MS Access 2000.

I have four users: A,B,C,D

They have an application named Projects

All four users enter their projects into the Projects application. All four users need to see all projects in the Projects application, but user A can only modify the projects he has entered into the Projects Application and user B can only modify the projects he has entered into the Projects Application.

If the Manager locks a project, then it can still be seen in the application but certain fields of the project can not be changed.

How do I setup SQL Server security for this application?
   

- Advertisement -