August 11, 2011 at 3:17 am
Hi all
I have a SQL 2008 database that I've upsized from Access. Since the upsize, a new table - dtproperties - has appeared in the list of tables. I understand this contains database diagram information that's no longer used.
Access users can see this table; can I remove it from their list in Access by making a change at the SQL end? Can I simply delete the table? I've read about removing it from the public role but I can't see how to do this (I'm using the Management Studio on the server itself) so I might need step-by-step instructions!
Thank you
August 11, 2011 at 6:14 am
Why are you concerned about displaying this table from Access?
This is not a security risk.
You could revoke permissions to the public role but no one would have access to the table.
Do you have the system and hidden objects unchecked in the objects menu?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
August 11, 2011 at 6:26 am
Thanks.
It's not about security in this case, it's about users not understanding why it's there and preferrring not to see it (in Access). A team of people have created an Access database to their own preferences, the idea being that I then move it up to SQL for them. They will continue to modify and work with the database from that point, again in Access, and I can build web interfaces too which expands the usefulness of the system overall.
When you say, 'revoke perissions to the public role', do you mean remove the public server role from the properties of the relevant user logins? (for clarity, I mean from the Security / Logins / user-right-click, properties, Server Roles area).
I don't know myself what it is and why it's there anyway, so any more info on the topic would be much appreciated.
Thanks again.
August 16, 2011 at 10:41 am
Delete the Access LINK to that table. You can do this by selecting the table in the tables list in Access and pressing the Delete key. It should inform you that you are just deleting the link, not the real table in SQL Server.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply