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

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