Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-10-27 : 10:46:35
|
Anoop writes "I am running SQL 7.0 and have a question about database security. I will be using DSN to access the database in ASP scripts, this DSN info will also be available to some other users so they can write scripts and extract data.
My question is: how would I restrict somebody from extracting a certain column in a table (say "class id number"); they should be able to search using the column but shouldn't have access to viewing the contents of that column (search for a "name" based on a the "class id number" but not the reverse).
It was found that one can disable SELECT on a column using direct SQL statements but not through any GUI in Enterprise Manager.
I have thought of using stored procedures or views to do the trick but am not sure if this will work. Any advice will be appreciated." |
|
|
|
|
|
Restricting certain permissions on columns.