且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何在Sql Server 2008中为表的列设置辅助功能

更新时间:2023-12-01 15:31:22

你正在寻找这里基于角色的安全性。您的数据库需要有以下表格:



You are looking for role based security here. Your data base needs to have following tables:

User
Role
Rights





现在,您的应用程序需要检查当前用户是否链接到有权更新值的角色。



Now, once you have this, your application needs to check if current user is linked to role which has right to update the values or not.