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 |
|
csphard
Posting Yak Master
113 Posts |
 Posted - 2002-11-18 : 18:25:18
|
| I went into the enterprise manage to a table and change the permissions to deny (red x) on select update insert and delete on public. However when i go to the query analyzer i can still select all from the table. Why?Now if i create a user and change there permissions to deny (red x) i can not select anything.(it works) What gives?help |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2002-11-18 : 19:11:05
|
| Maybe MS has added this feature on purpose because if you deny rights to public, dbo accounts (including sa) won't even be able to get to the tables. So this must be a feature, but MS should let you know that it couldn't do it. You might want to create a role and put all accounts in that role, then deny access to the role. This is the preferred method anyway. |
 |
|
|
|
|
|
permissions