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.
| Author |
Topic |
|
anupalavila
Yak Posting Veteran
56 Posts |
 Posted - 2008-10-06 : 02:11:16
|
| Hi In my employeemanagement database there is a table named empattendances which is used to enter the employees attendances, Is there any way to lock the table empattendances which prevents the employees to change their attendance detailsThanks and Regards Anu Palavila |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-10-06 : 02:25:26
|
| Are the values Entered manually ? Its best you secure your server and enable access via a frontend whereby you have a management system/application. Thats how best its done |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-06 : 02:28:51
|
| do you mean restricting access only to some people with sufficeint rights? |
|
|
|
anupalavila
Yak Posting Veteran
56 Posts |
Posted - 2008-10-06 : 02:45:05
|
| ya the attendance marking is done through a C#.net application in to a database which have username and password for the sqlserverbut some of the employees know this username and password since they are working on some other databases in the same server how to restrict access to only some people with sufficent rights only for this database in the server or only the table empattendances Thanks and Regards Anu Palavila |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-06 : 02:53:08
|
quote:
Originally posted by anupalavila
ya the attendance marking is done through a C#.net application in to a database which have username and password for the sqlserverbut some of the employees know this username and password since they are working on some other databases in the same server how to restrict access to only some people with sufficent rights only for this database in the server or only the table empattendances Thanks and Regards Anu Palavila
dont give users direct update,insert rights to tables. create stored procedure for insert/update and give execute permission only for those who really need to change data. for others just give select rights alone. |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-10-06 : 03:01:39
|
| I agree,I advice put your logic in the c# app, you need a management system of some sort in your office, whereby different users DB have different roles/permissions |
|
|
|
|
|
|
lock a table in a database