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

From: Roji. P. Thomas (thomasroji_at_gmail.com)
Date: 11/29/04 

Date: Mon, 29 Nov 2004 15:04:37 +0530

GRANT SELECT (<ColumnName>) ON <TableName> TO <User> 

-- 
Roji. P. Thomas
Net Asset Management
https://www.netassetmanagement.com
"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
>
>

Relevant Pages

  • Re: Unable to access FP extensions admin/permissions from site on
    ... You need to contact your web host to see if they will give you permissions to access the FP Admin ... Microsoft MVP - FrontPage ... "Thomas A. Rowe" wrote: ...
    (microsoft.public.frontpage.extensions.windowsnt)
  • Re: Insert Query taking ages....
    ... P. Thomas ... > table command in query analyser and it also just sits there for ages.... ... >>> Roji. ... >>> Net Asset Management ...
    (microsoft.public.sqlserver.programming)
  • Re: DISTINCT and LEFT JOIN problem
    ... P. Thomas ... >>> Roji. ... >>> Net Asset Management ... >>>>> community of SQL Server professionals. ...
    (microsoft.public.sqlserver.programming)
  • Re: How to concat the values in a column across rows.
    ... P. Thomas ... "Colin Halliday" wrote in message ... >> Roji. ... >> Net Asset Management ...
    (microsoft.public.sqlserver.programming)
  • Re: ASP / Redirect
    ... P. Thomas ... >:> Roji. ... >:> Net Asset Management ... ' Render your page here ...
    (microsoft.public.inetserver.asp.general)