Row Level Security (RLS) in SQL Server 2016

แชร์
ฝัง
  • เผยแพร่เมื่อ 29 ต.ค. 2024

ความคิดเห็น • 10

  • @Fullcontact1992
    @Fullcontact1992 4 ปีที่แล้ว

    Awsomely clear. Could you please enlighten me above row and Column level security what else you can use as security solution in business ?

  • @ajitharik
    @ajitharik 6 ปีที่แล้ว +2

    what is "select 1 as result in the table valued function" exactly doing ?

    • @SQLwithManoj
      @SQLwithManoj  6 ปีที่แล้ว

      "SELECT 1" is just used to make sure the query returns at least 1 row. If there is no row returned then the user is not allowed to see that data.

  • @swapnilmehta4411
    @swapnilmehta4411 5 ปีที่แล้ว +1

    Very helpful, but What if the user know all that three USER ''userHR", "userFin" and "userCEO"? a user can show all the records by using Execute as USER.

    • @SQLwithManoj
      @SQLwithManoj  5 ปีที่แล้ว

      The normal user can't use "EXECUTE as USER" until he has admin rights :)

  • @digitalmedia4816
    @digitalmedia4816 8 ปีที่แล้ว +1

    Interesting tech tutorials.

  • @spavas
    @spavas 5 ปีที่แล้ว

    How can we achieve Row Level Security with multiple users for one row

  • @ZioPio
    @ZioPio 7 ปีที่แล้ว +1

    Very usefull! thanks!

  • @Rmbali1
    @Rmbali1 6 ปีที่แล้ว +1

    tankyou very usefull
    but when i grant to user first user is ok but second and so on dont get gran and get me an error: User does not have permission to perform this action.

    • @SQLwithManoj
      @SQLwithManoj  6 ปีที่แล้ว

      You may be trying to create a new user after switching the context to previously created user. Try using REVERT; statement before creating another user.