Re: table security

From: Erland Sommarskog (esquel_at_sommarskog.se)
Date: 01/01/05

  • Next message: Hassan: "windows authentication from web servers" 
    Date: Sat, 01 Jan 2005 06:53:46 -0800

    Jim (peesa_govno@hotmail.com) writes:
    > I want to implement security based on permissions for groups. So
    > administratorsusers have access to all rows of a certain table/view whilst
    > users with less priviliges have access to a limited amount of rows. I was
    > thinking storing the tablecolumn + value in a table and then updating the
    > whereclause dynamically...

    Better to defined a view where you join to table which define which rows
    a user may see. Then grant no access to the table, but all access to the
    table. No need for dynamic WHERE clauses. 

    -- 
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
  • Next message: Hassan: "windows authentication from web servers"

    Relevant Pages

    • table security
      ... I want to implement security based on permissions for groups. ... administratorsusers have access to all rows of a certain table/view whilst ... users with less priviliges have access to a limited amount of rows. ...
      (microsoft.public.sqlserver.security)
    • table security
      ... I want to implement security based on permissions for groups. ... administratorsusers have access to all rows of a certain table/view whilst ... users with less priviliges have access to a limited amount of rows. ...
      (microsoft.public.sqlserver.server)
    • Re: table security
      ... Jim wrote: ... > I want to implement security based on permissions for groups. ... > administratorsusers have access to all rows of a certain table/view ...
      (microsoft.public.sqlserver.server)
    • RE: What server hardening are you doing these days?
      ... permissions on their data, and Microsoft encourages ISVs to minimize ... I've been able to discuss ACLs and other security issues in Windows with ... Control or DAC (which is what you're referring to by the "stupid ...
      (Focus-Microsoft)
    • Re: get rid of security center?
      ... I have come up with a solution that does not disable Security Center, ... By changing the Permissions of that key, ... settings from being changed again. ... the firewall alert settings in Security Center get ...
      (microsoft.public.windowsxp.help_and_support)