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

From: AlanM (nooneatall_at_nowhere.com)
Date: 11/29/04

Next message: Charles Lin: "sql icon disappear from sys tray and getting SQL-DMO 80040005 erro"
Previous message: JMBickham: "External logs collection and monitoring"
Next in thread: Roji. P. Thomas: "Re: I want to give a user access to only one field in one table"
Reply: Roji. P. Thomas: "Re: I want to give a user access to only one field in one table"
Reply: Dan Guzman: "Re: I want to give a user access to only one field in one table"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

Date: Mon, 29 Nov 2004 17:00:21 +0800

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: Charles Lin: "sql icon disappear from sys tray and getting SQL-DMO 80040005 erro"
Previous message: JMBickham: "External logs collection and monitoring"
Next in thread: Roji. P. Thomas: "Re: I want to give a user access to only one field in one table"
Reply: Roji. P. Thomas: "Re: I want to give a user access to only one field in one table"
Reply: Dan Guzman: "Re: I want to give a user access to only one field in one table"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

Relevant Pages

Re: Logging in irrespective of database access
... Sysadmin role members have full permissions, ... SQL Server MVP ... > My problem is that in the Login section of Enterprise Manger I have to> specify that each login has the System Admin ticked under Server Roles> because in SQL 2000 there doesn't seem to a Grant All permissions option> like there used to be in SQL 6.5. ... > What's the point in having the Database Access section if the System Admin> under Server Roles allows you to get into anything?. ...
(microsoft.public.sqlserver.programming)
Re: Logging in irrespective of database access
... Sysadmin role members have full permissions, ... SQL Server MVP ... > My problem is that in the Login section of Enterprise Manger I have to> specify that each login has the System Admin ticked under Server Roles> because in SQL 2000 there doesn't seem to a Grant All permissions option> like there used to be in SQL 6.5. ... > What's the point in having the Database Access section if the System Admin> under Server Roles allows you to get into anything?. ...
(microsoft.public.sqlserver.programming)
Re: Logging in irrespective of database access
... Sysadmin role members have full permissions, ... SQL Server MVP ... > My problem is that in the Login section of Enterprise Manger I have to> specify that each login has the System Admin ticked under Server Roles> because in SQL 2000 there doesn't seem to a Grant All permissions option> like there used to be in SQL 6.5. ... > What's the point in having the Database Access section if the System Admin> under Server Roles allows you to get into anything?. ...
(microsoft.public.sqlserver.server)
Re: Logging in irrespective of database access
... Sysadmin role members have full permissions, ... SQL Server MVP ... > My problem is that in the Login section of Enterprise Manger I have to> specify that each login has the System Admin ticked under Server Roles> because in SQL 2000 there doesn't seem to a Grant All permissions option> like there used to be in SQL 6.5. ... > What's the point in having the Database Access section if the System Admin> under Server Roles allows you to get into anything?. ...
(microsoft.public.sqlserver.server)
Re: List Users Permissions down to table.column action
... THIS STORED PROCEDURE GENERATES COMMANDS ... -- FIXED PROBLEMS WITH STATEMENT LEVEL PERMISSIONS GRANTING. ... -- CREATE TABLE TO HOLD LIST OF USERS IN CURRENT DATABASE ... -- GRANT USER ACCESS TO SERVER ROLES ...
(microsoft.public.sqlserver.security)