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 |
|
inbs
Aged Yak Warrior
860 Posts |
 Posted - 2009-10-26 : 08:22:05
|
| how in sql server managment studio, can i allow user to see one table and deny the other?i meanhe can see tableA,tableB but he can't have acess to tableC,tableD....... |
|
|
jimf
Master Smack Fu Yak Hacker
2875 Posts |
|
|
inbs
Aged Yak Warrior
860 Posts |
Posted - 2009-10-26 : 09:29:06
|
| if i grant to user permission to just to table_A ,so it mean the user cant see the other tables?GRANT SELECT ON Customers TO domain\Joe, domain\Mary |
 |
|
|
jimf
Master Smack Fu Yak Hacker
2875 Posts |
Posted - 2009-10-26 : 11:16:49
|
| You may need to specifically DENY permissions on other tables.JimEveryday I learn something that somebody else already knew |
|
|
|
inbs
Aged Yak Warrior
860 Posts |
Posted - 2009-10-26 : 13:19:59
|
| but it is a lot of tables (around 70 tables)i need to deny all permission for each table??for TABLE_Aalter denycontrol deny....selct denyfor TABLE_Balter denycontrol deny....selct deny |
|
|
|
inbs
Aged Yak Warrior
860 Posts |
Posted - 2009-10-27 : 07:00:42
|
| never mine i succeded |
|
|
|
|
|
|
SSMS-Permission