SQL Public Role and Navision on SQL 2005

NavStudent
NavStudent Member Posts: 399
edited 2006-08-10 in NAV/Navision Classic Client
Hello I've been playing with SLQ 2005 and I've setup a public role to a db user. The user can login through excel and see the following views/tables. How Can I prevent this from happening


$ndo$dbproperty
all columns
all_objects
all_parameters
all_views
.....the list goes one
xml_schema_whildcards


Also if the user installs SQL Server management Studio they cannect to the server and see a lot more. From permission perspecitve they cannot change anything, I tried to delete just one of the system tables, but errored out on permission, but is there a way to remove those from public role? or prevent users to connect through excel?
my 2 cents

Categories