如何为用户设置特定列的插入限制？ [英] How to set insert restricted for a particular column by users' ?

问题描述

如何在SQLServer中为表中的列设置插入权限。请举例。



详细信息：用户无法插入或更新特定的列值（即datetime数据类型），但它会插入或更新当前值每个插入或更新数据的系统日期时间。请举例。

How to set the permission to insert for a column in a table in SQLServer. Please give an example.

in Details: User can't insert or update a particular column values(i.e. datetime datatype) but it'll insert or update values from current date time of system for every insert or update data. Please give an example.

推荐答案

您可以通过计算列限制用户插入/更新数据。但是对于你的要求，计算列不能用作在不同时间返回不同结果的相同函数。



因此，你可以让列接受getdate（）默认值并创建一个而不是触发器，以确保无论用户插入该列，它将被当前日期戳替换。



如果您需要有关代码的帮助，请让我知道：）

You can restrict data insert/update by user through computed column. But for your requirement computed column can not be used as same function returning different result at different time.

So, you can make the column to accept getdate() default value and create an instead of trigger to make sure that whatever the user inserts to that column, it will be replaced by current datestamp.

In case you need help with code, please let me know :)

这篇关于如何为用户设置特定列的插入限制？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！