Re: table security

From: David Gugick (davidg-nospam_at_imceda.com)
Date: 12/31/04 

Date: Fri, 31 Dec 2004 03:33:02 -0500

Jim wrote:
> 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

You should do this using the built-in SQL Server security, not using a
home grown process. You can add roles and then assign users to those
roles. You can then grant and revoke rights for each role. See BOL topic
"Roles" for more information. 

-- 
David Gugick
Imceda Software
www.imceda.com

Relevant Pages

  • Re: Open Facebook Sandwich
    ... WRT security, what you put in about yourself and level of detail in your profile is really up to you, but there are some settings which I've been looking at which 'may' help those with concerns. ... at least you'll die from some event in which you've been a participant (though jim doesn't really allow many choices), rather than from some accident you'd never anticipate happening. ... i merely attended a penns creek gathering...was warned frank was near... ... jeff ...
    (rec.outdoors.fishing.fly)
  • Re: Organize Computers In Active Directory
    ... Thank you, that's what I thought, but since security is so ... Jim ... >Brian Desmond ... >> the computer into their own little OU effect permissions ...
    (microsoft.public.win2000.active_directory)
  • Re: Time to Pay Again, Dinks!
    ... McDonald, vice president, secretary and general counsel of Brink's Home ... Security. ... of course they wont pursue further.... ... they are hoping to get the 1.4 millions from Jim;-) ...
    (alt.security.alarms)
  • Re: About Google Chrome Browser
    ... jim said this on 12/17/2008 7:46 PM: ... IE Banking Etc.? ... Some one just posted a link to a report comparing the major browsers and their security and how easy it is for forms,java etc to extract passwords. ...
    (microsoft.public.windowsxp.general)
  • 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)
Quantcast