October 15, 2003 at 8:51 am
I have the users who connect to SQL server remotely, their accounts were only assigned to the specific database on SQL server, but they still can see all the databases, is there a way to hide the databases?
The same issue with the linked server that connect to Oracle, they can even see the properties of linked server remotely.
October 15, 2003 at 9:44 am
quote:
but they still can see all the databases, is there a way to hide the databases?
They should be able to see the databases but unable to access them. If they do, check whether you have 'guest' user in those databases or they are in some of server roles/database roles.
quote:
The same issue with the linked server that connect to Oracle, they can even see the properties of linked server remotely.
They shouldn't see linked server properties unless the login they use is members of the sysadmin and setupadmin fixed server roles.
October 16, 2003 at 9:34 am
I would also make sure that your public roles do not have object permissions.
RandyHelpdesk: Perhaps Im not the only one that does not know what you are doing. 😉
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply