|
Home > Archive > MS SQL Server > October 2006 > restrict enterprise manager to see all the databases
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
restrict enterprise manager to see all the databases
|
|
| murtix van basten 2006-10-24, 6:30 pm |
| Hi,
my question is about security, but I am sure it has something to do
with the server configuration. It is about normal users other than SA.
In the server, multiple users, and each user has ownership of a
seperate database. When any of these users connect to the sql server
via Enterprise Manager, they are able to see all the databases, not
only they owned, also other databases they do not have ownership of.
Not that, they can see the tables or the data, but this still
bothers the user(s). How can I restrict the normal users to see only
their database(s) when they logged in thru enterprise manager with
their username and password ?
I aplogize if this quesiton has asked before and answered. If so,
please direct me to the correct link, I could not seek it.
Thank you.
| |
| Hari Prasad 2006-10-24, 6:30 pm |
| Hi,
As far as I know there is a no way to restrict this in enterprise manager.
You can only hide system databases and system tables
from SQL Server's Registration Properties.
Thanks
Hari
SQL Server MVP
"murtix van basten" <murtix@gmail.com> wrote in message
news:1158899177.310068.275240@d34g2000cwd.googlegroups.com...
> Hi,
>
> my question is about security, but I am sure it has something to do
> with the server configuration. It is about normal users other than SA.
>
> In the server, multiple users, and each user has ownership of a
> seperate database. When any of these users connect to the sql server
> via Enterprise Manager, they are able to see all the databases, not
> only they owned, also other databases they do not have ownership of.
>
> Not that, they can see the tables or the data, but this still
> bothers the user(s). How can I restrict the normal users to see only
> their database(s) when they logged in thru enterprise manager with
> their username and password ?
>
> I aplogize if this quesiton has asked before and answered. If so,
> please direct me to the correct link, I could not seek it.
>
> Thank you.
>
| |
| Tracy McKibben 2006-10-24, 6:30 pm |
| murtix van basten wrote:
> Hi,
>
> my question is about security, but I am sure it has something to do
> with the server configuration. It is about normal users other than SA.
>
> In the server, multiple users, and each user has ownership of a
> seperate database. When any of these users connect to the sql server
> via Enterprise Manager, they are able to see all the databases, not
> only they owned, also other databases they do not have ownership of.
>
> Not that, they can see the tables or the data, but this still
> bothers the user(s). How can I restrict the normal users to see only
> their database(s) when they logged in thru enterprise manager with
> their username and password ?
>
> I aplogize if this quesiton has asked before and answered. If so,
> please direct me to the correct link, I could not seek it.
>
> Thank you.
>
Can't do this with Enterprise Manager...
--
Tracy McKibben
MCDBA
http://www.realsqlguy.com
| |
| murtix van basten 2006-10-24, 6:30 pm |
| Thank you for the answers.
Tracy McKibben wrote:
> murtix van basten wrote:
>
> Can't do this with Enterprise Manager...
>
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
|
|
|
|
|