Re: I want to give a user access to only one field in one table

From: Dan Guzman (guzmanda_at_nospam-online.sbcglobal.net)
Date: 11/29/04

  • Next message: Drasko Ivanisevic: "Re: How can i restrict the SA user" 
    Date: Mon, 29 Nov 2004 07:31:13 -0600

    To add to Roji's response, you might also consider creating a view that
    returns only the data the user should see and grant SELECT permissions on
    only that view to the user/role. This allows vertical and horizontal
    partitioning based on your requirements. See 'Using Views as Security
    Mechanisms' <adminsql.chm::/ad_security_5whf.htm> in the Books Online for
    more information.

    CREATE VIEW MyView
    AS
    SELECT MyColumn
    FROM MyTable
    GO

    GRANT SELECT ON MyView TO MyRole
    GO 

    -- 
Hope this helps.
Dan Guzman
SQL Server MVP
"AlanM" <nooneatall@nowhere.com> wrote in message 
news:ObRkcHf1EHA.1204@TK2MSFTNGP10.phx.gbl...
>I was trying to give permissions to a user for one field in one table only.
>
> How can I do this?
>
> It seems that I have to give permissions to the whole database.
>
> I have SQL 2000 using Enterprise manager
>
>
  • Next message: Drasko Ivanisevic: "Re: How can i restrict the SA user"

    Relevant Pages

    • Re: Create table in schema
      ... SQL Server MVP ... Every time I try to grant control to the dds_pco_role, ... Cannot grant, deny, or revoke permissions to sa, dbo, entity owner, ... I also got that when I ran grant alter on schema. ...
      (microsoft.public.sqlserver.security)
    • Re: USERS group has the ability to change security permissions???
      ... Please use the Advance view in the NTFS permissions dialog to ... When there is a generic grant and a special grant to the same entity ... the RESULT: user level access can change NTFS ...
      (microsoft.public.win2000.security)
    • Re: DCOM Event ID 10015
      ... Grant the user permissions to start the COM component ... Run the MPSRPT_DirSvc.exe on the server box. ... Microsoft CSS Online Newsgroup Support ...
      (microsoft.public.windows.server.sbs)
    • Re: NTFS woes
      ... "In some cases with a grant of Full is reduced ... NTFS permissions dialog. ... check Allow Delete Subfolders and Files ... Explicit Deny Delete on file does not work (user can still delete ...
      (microsoft.public.windows.server.security)
    • Re: NTFS woes
      ... "In some cases with a grant of Full is reduced ... NTFS permissions dialog. ... check Allow Delete Subfolders and Files ... Explicit Deny Delete on file does not work (user can still delete ...
      (microsoft.public.windows.server.security)