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 |
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
 Posted - 2007-11-20 : 18:05:58
|
| I set up user and linked access in sql and the user can see the tables i give access to but they also see dbo.dtproperties, dbo.syscontraints, dbo.sysegments.Does the user have to have public (removed) ?I do not want user to see these Thanks |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-22 : 22:21:17
|
| Unless you deny permision on those objects from users. |
 |
|
|
|
|
|
Linked server with acccess sees dbo.sys