sql_language thread: How do i deny permissson to a user to access a particular column of a table?
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.