Limit Access to DB

Hi,

How do I limit access to a sql db?  I do not want any user to be able to
view the db in enterprise manager.

Thanks

That feature is not available in SQL 2000.  Any authorized SQL user can view
the entire list of all databases.

Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Ron Mexico" <ronm@mvick.com> wrote in message
news:ehMc60SxFHA.3436@TK2MSFTNGP10.phx.gbl...
> Hi,
>
> How do I limit access to a sql db?  I do not want any user to be able to
> view the db in enterprise manager.
>
> Thanks
>

Will this feature be in 2005, specifically express edition?

Thanks

"Geoff N. Hiten" <SRDBA@Careerbuilder.com> wrote in message
news:%23xcecNTxFHA.3556@TK2MSFTNGP12.phx.gbl...
> That feature is not available in SQL 2000.  Any authorized SQL user can
> view the entire list of all databases.
>
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
> "Ron Mexico" <ronm@mvick.com> wrote in message
> news:ehMc60SxFHA.3436@TK2MSFTNGP10.phx.gbl... 
>
>

Why are your end-users using Enterprise Manager anyway?  Is this a
requirement?  If not, do not allow the end-users to use EM and that should
resolve "this" issue.

HTH

Jerry
"Ron Mexico" <ronm@mvick.com> wrote in message
news:%23pEXZQTxFHA.1028@TK2MSFTNGP12.phx.gbl...
> Will this feature be in 2005, specifically express edition?
>
> Thanks
>
> "Geoff N. Hiten" <SRDBA@Careerbuilder.com> wrote in message
> news:%23xcecNTxFHA.3556@TK2MSFTNGP12.phx.gbl... 
>
>

I currently do not have an app using MS SQL.  The reason I am curious about
this issue is that we have third party apps that use SQL and I am EM on the
server and I can see the db.  How can I stop users from having EM when they
could need for other apps they have installed?


"Jerry Spivey" <jspivey@vestas-awt.com> wrote in message
news:%23Ywd8GYxFHA.720@TK2MSFTNGP10.phx.gbl...
> Why are your end-users using Enterprise Manager anyway?  Is this a
> requirement?  If not, do not allow the end-users to use EM and that should
> resolve "this" issue.
>
> HTH
>
> Jerry
> "Ron Mexico" <ronm@mvick.com> wrote in message
> news:%23pEXZQTxFHA.1028@TK2MSFTNGP12.phx.gbl... 
>
>

Ron,

Typically end-users do not need nor use Enterprise Manager.  That being said
if an end user did install EM and could see the database listings the
end-user would still be required to have a database user account in each
database listed to see the contents of the database.  So the table contents
are still secure reguardless.

HTH

Jerry
"Ron Mexico" <ronm@mvick.com> wrote in message
news:uoecm7cxFHA.2924@TK2MSFTNGP15.phx.gbl...
>I currently do not have an app using MS SQL.  The reason I am curious about
>this issue is that we have third party apps that use SQL and I am EM on the
>server and I can see the db.  How can I stop users from having EM when they
>could need for other apps they have installed?
>
>
> "Jerry Spivey" <jspivey@vestas-awt.com> wrote in message
> news:%23Ywd8GYxFHA.720@TK2MSFTNGP10.phx.gbl... 
>
>

Thanks for the help.  So, when installed my db on a system that has sql
server, I would have an account for that db instaed of using sa?

Thanks
"Jerry Spivey" <jspivey@vestas-awt.com> wrote in message
news:%23bZb6AdxFHA.1168@TK2MSFTNGP15.phx.gbl...
> Ron,
>
> Typically end-users do not need nor use Enterprise Manager.  That being
> said if an end user did install EM and could see the database listings the
> end-user would still be required to have a database user account in each
> database listed to see the contents of the database.  So the table
> contents are still secure reguardless.
>
> HTH
>
> Jerry
> "Ron Mexico" <ronm@mvick.com> wrote in message
> news:uoecm7cxFHA.2924@TK2MSFTNGP15.phx.gbl... 
>
>

I'd recommend creating a login (access to SQL Server) and a mapped database
user account (access to the database) with the appropriate permission rather
than using the sa login.  If this login requires full permissions (i.e., dba
or dev) add the login to the fixed server role sysadmin.

HTH

Jerry
"Ron Mexico" <ronm@mvick.com> wrote in message
news:%230sh0RdxFHA.2132@TK2MSFTNGP15.phx.gbl...
> Thanks for the help.  So, when installed my db on a system that has sql
> server, I would have an account for that db instaed of using sa?
>
> Thanks
> "Jerry Spivey" <jspivey@vestas-awt.com> wrote in message
> news:%23bZb6AdxFHA.1168@TK2MSFTNGP15.phx.gbl... 
>
>