如何使某些列可编辑，而某些列不能在引导数据库表中编辑？

-- 创建一个角色
CREATE ROLE ReadOnlyRole;

-- 授予角色对表的SELECT权限
GRANT SELECT ON YourTable TO ReadOnlyRole;

-- 授予角色对特定列的UPDATE权限
GRANT UPDATE (EditableColumn1, EditableColumn2) ON YourTable TO ReadOnlyRole;

-- 将用户添加到角色
EXEC sp_addrolemember 'ReadOnlyRole', 'YourUser';

CREATE TRIGGER trg_PreventUpdateOnCertainColumns
ON YourTable
INSTEAD OF UPDATE
AS
BEGIN
    SET NOCOUNT ON;
    -- 允许更新可编辑的列
    UPDATE YourTable
    SET EditableColumn1 = inserted.EditableColumn1,
        EditableColumn2 = inserted.EditableColumn2
    FROM YourTable
    INNER JOIN inserted ON YourTable.PrimaryKey = inserted.PrimaryKey;
    -- 阻止更新不可编辑的列
    IF EXISTS (SELECT 1 FROM inserted WHERE inserted.NonEditableColumn1 <> YourTable.NonEditableColumn1)
    BEGIN
        RAISERROR ('Update on NonEditableColumn1 is not allowed.', 16, 1);
        ROLLBACK TRANSACTION;
    END
END;

-- 创建一个视图，只包含可编辑的列
CREATE VIEW vw_EditableYourTable AS
SELECT EditableColumn1, EditableColumn2
FROM YourTable;

-- 授予用户对视图的UPDATE权限
GRANT UPDATE ON vw_EditableYourTable TO YourUser;