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 |
|
hardboiled
Starting Member
6 Posts |
 Posted - 2006-12-12 : 04:27:52
|
| I'm new to dba'ing so go easy on me. I'm looking after a brand new installation of sql server 2005. I've created a simple db with 1 table but when I go to MSAccess ( as a newly created user) and create a linked table to sql database all the metadata is showing and I can't stop it. I've tried going through securables but its still visible no matter how much I try to deny. From what I've read this shouldn't be possible as making metadata invisible should be standard.Can anyone throw any light on this? |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2006-12-12 : 06:18:29
|
what metadata are you talking about?can you be more specific?Go with the flow & have fun! Else fight the flow  blog thingie: http://weblogs.sqlteam.com/mladenp |
 |
|
|
hardboiled
Starting Member
6 Posts |
Posted - 2006-12-12 : 08:40:53
|
| information_schema.**** and sys.***** tables. They're all visible to the users when they map access linked tables through ODBC links.Surely that's not right. I certainly didn't have this problem with sql server 2000, but I've got it now. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2006-12-12 : 17:25:09
|
| Does your ODBC connection specify a database? If not it will use the default db for that login, or master. |
|
|
|
hardboiled
Starting Member
6 Posts |
Posted - 2006-12-13 : 05:59:38
|
| Yep. It certainly does specify the correct db. No one seems to be able to work this one out. |
|
|
|
|
|
|
Metadata wont go away(sql server2005)