table security

From: Jim (peesa_govno_at_hotmail.com)
Date: 12/31/04 

Date: Fri, 31 Dec 2004 15:36:57 +1100

Hi

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...

Thanks

Jim

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.server)
  • Re: table security
    ... > I want to implement security based on permissions for groups. ... > administratorsusers have access to all rows of a certain table/view whilst ...
    (microsoft.public.sqlserver.security)
  • Re: slow iis 6.0 performance
    ... > Where could I get a list of permissions that I need to set? ... > web servers I added this user to IIS_WPG. ... If the security tokens are not cached for a domain user we have a problem. ... this user must have some priviliges such as for schannel. ...
    (microsoft.public.inetserver.iis)
  • Re: slow iis 6.0 performance
    ... Where could I get a list of permissions that I need to set? ... done this is setup the domain user account on the DC. ... permissions required on the local web server? ... this user must have some priviliges such as for schannel. ...
    (microsoft.public.inetserver.iis)