Different access right for all users in Windows application

  • Thread starter Thread starter TH
  • Start date Start date
T

TH

Hi,

I'm trying to find out the best way to control the access rights for several
users that work with data stored in a database..
Updating certain database-fields must be restricted / unaccessible (read
only) for users with the lowest rankings.. Only toplevel-user must be able
to do this..
Planning to use 4 levels of user rights,
Default user/ superuser/ administrator / database owner.

I'm using SQL server 2000, so I guess this can be used best to store
security levels for users?
Anybody that has some tips?
 
Addon:

On program start, the user should get a logon screen, before he's able to do
anything.
From the data entered on this logon box, access rights should be applied.
 
Back
Top