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 |
|
Gsuttie
Starting Member
14 Posts |
 Posted - 2001-12-17 : 05:52:42
|
| Im a little unclear about database permissions with regards to deny, grant and so on. Having read BOL I'd still like to ask one or 2 quetsions in here.Say there is a table with columns a,b, c and d. I have select permissions on columns a and b but I have been denied permissions on columns c and d. What do I need to do to to allow me to see all columns?Does deny override all other permissions, and if so do i need to revoke the deny before allowing select ?Thanks for any helpGregorGreg |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2001-12-17 : 07:49:35
|
| deny overrides select.You do need to revoke it.I think.should be easy to test.==========================================Cursors are useful if you don't know sql.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Database Permissions