分配权限以查看数据（记录） [英] assigning rights to see the data(records)

问题描述

嗨朋友,,,,





我有一个名为CallRegister的表，我们正在维护其中的所有Call记录。







作为 admin ，我可以看到所有的通话记录但是我不希望我的高管能看到所有的记录。他们只能看到他们输入软件的记录。





我有一个网格，我编码为

Hi friends,,,,


I have a table called CallRegister and we are maintaining all the Call records in it.



As a admin i can see all the call records but i don''t want my executives can see all the records. They can see only their records which they have entered into software.


I have a grid and i have coded as

select *from CallRegister where username=Textbox1.text

请建议我如何使用SQL查询限制用户级别的数据访问。

please suggest me how can restrict data access to user levels using SQL queries.

推荐答案

您必须使用行级安全性（RLS）。



详细信息可以在以下位置找到： -



http://msdn.microsoft.com/en-us/library/bb669076.aspx [ ^ ]

You have to use Row Level Security(RLS).

Detail about this can be found at below location :-

http://msdn.microsoft.com/en-us/library/bb669076.aspx[^]

这篇关于分配权限以查看数据（记录）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！