Wrox Home  
Search P2P Archive for: Go

  Return to Index  

sql_language thread: How do i deny permissson to a user to access a particular column of a table?


Message #1 by "bio jay" <jay_sh2k1@y...> on Mon, 18 Jun 2001 18:41:34
Hi, Am new to SQL and SQL server. I have a database with a table called 
grades with a 'grade' field. I want to deny permission to a 'student' user
from accessing the grades column, that is preventing the user from 
entering or deleting grades. How do I do this. I looked up the SQL seerver 
book online but am still having problems. Here is the command I used.
"DENY INSERT, UPDATE, DELETE grade ON grades TO student"
Please help. - jay.

  Return to Index