Re: Permissions

From: Dan Guzman (danguzman_at_nospam-earthlink.net)
Date: 11/27/03 

Date: Thu, 27 Nov 2003 09:16:17 -0600

Yes, you can grant permissions on specific columns. However, the vertical
partitioning method suggested by Ryan works well.because you don't need to
grant permissions on the referenced table (assuming the objects have the
same owner). This will hide the columns excluded from the view and avoid
permissions errors. 

-- 
Hope this helps.
Dan Guzman
SQL Server MVP
"Alexander Szigetvary" <rsa.news@gmx.at> wrote in message
news:O9t2k3NtDHA.684@TK2MSFTNGP09.phx.gbl...
> Hi NG!
>
> Is it possible to give permissions to specific columns in a table or does
> the whole table has to have the same permissions?
>
> TIA
>
> A. Szigetvary
>
>

Relevant Pages

  • Re: CreateFile() returns ERROR_ACCESS_DENIED to the user
    ... grant permissions for power users on the device driver and then do a ... relogon with power user or there is some other place where the ... permissions can be granted? ... users cannot grant permissions to themselves, ...
    (microsoft.public.win32.programmer.kernel)
  • Re: Security options for 2005 Native XML Web Services (ENDPOINT)
    ... You can use groups to grant permissions for the endpoint. ... Jasper Smith (SQL Server MVP) ...
    (microsoft.public.sqlserver.security)
  • Re: Word Automation - System.UnauthorizedAccessException on Winforms
    ... You need to check out "How to: Grant Permissions to Folders and Assemblies" ... > I have written a word automation application in c#, ... > to create a word object and open a document, ...
    (microsoft.public.office.developer.automation)
  • RE: A-G-DL-P strategy
    ... But in my case, I can't grant permissions to a DLG group, because on the ... The only groups I can grant permissions are DG groups. ... > DLGs can contain members from any domain but can only be used to permission ...
    (microsoft.public.windows.server.active_directory)
  • Re: Granting file access permissions
    ... > have those permissions flow down to all child OUs? ... >> You can grant permissions based on OUs. ... >> Microsoft MVP - Windows Security ...
    (microsoft.public.windows.server.general)