Sql Server 2005 Management Studio

27 Feb 2007 5:01 PM

jameskil

Are there any techniques for locking down features of Management Studio? Nice
tool, but its like givng out a loaded gun to low experienced users.

--
jameskil

27 Feb 2007 5:44 PM

Tibor Karaszi

Not in the tool per se. Make sure that the users don't have more permissions than necessary. Btw,
SSMS wasn't meant as an end.user tool... :-)

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi

Show quote

"jameskil" <james***@discussions.microsoft.com> wrote in message
news:D8CD1306-B407-4114-A568-564F5921DDB3@microsoft.com...
> Are there any techniques for locking down features of Management Studio? Nice
> tool, but its like givng out a loaded gun to low experienced users.
> --
> jameskil

27 Feb 2007 5:54 PM

Ed Murphy

jameskil wrote:

> Are there any techniques for locking down features of Management Studio? Nice
> tool, but its like givng out a loaded gun to low experienced users.

We were asked the same question by a client about the boatload
of Access front-ends left behind by our cowboy coder of a
predecessor. The right answer (or at least the first part of
it) is to lock down the permissions of their SQL logins.

Sql Server 2005 Management Studio - Lock Down