Hi everyone,
Is there a possibility to block SQL user using Enterprise Manager from
listing other databases on SQL server?
Every user can see the list of databases but can change only his database.
Is there a way to set it up just his own and nothing else.
Suggestions, links, ... appreciated
Thanks,
BorkoNot with the current version. SQL2005 will have more ways to handle things
like this.
Andrew J. Kelly SQL MVP
"borko" <borko@.borko.co.co> wrote in message
news:ctal4s$cg1$1@.ls219.htnet.hr...
> Hi everyone,
> Is there a possibility to block SQL user using Enterprise Manager from
> listing other databases on SQL server?
> Every user can see the list of databases but can change only his database.
> Is there a way to set it up just his own and nothing else.
> Suggestions, links, ... appreciated
> Thanks,
> Borko
>
>
Friday, March 9, 2012
Enterprise Manager list databases
Labels:
block,
database,
databases,
enterprise,
fromlisting,
manager,
microsoft,
mysql,
oracle,
possibility,
server,
serverevery,
sql,
user
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment