Re: Enterprise manager security?
From: Steve Thompson (SteveThompson_at_nomail.please)
Date: 03/04/04
- Next message: Shad: "RE: local system question"
- Previous message: Steve Thompson: "Re: local system question"
- In reply to: rick m: "Enterprise manager security?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Thu, 4 Mar 2004 13:09:30 -0500
"rick m" <anonymous@discussions.microsoft.com> wrote in message
news:03A80E82-BAF0-4055-AEA7-9C33AEB30DB8@microsoft.com...
> Our product has the middleware conduct transactions with the SQL server
using a special account. The developers know the account and password in
order to code it in their apps. The problem is that they are not allowed
access to the platform once an app goes into production (we are in the
banking industry). However, they use Enterprise Manager and as long as they
know the account name and password, they can still get to any of the
databases.
>
> Anyone know how to stop a connection to a SQL DB (by user) with Enterprise
Manager?
No direct way, you'd be better off blocking (or simply removing any security
permissions) for user connections to the server running SQL Server. I agree
with the other posts, the main thing to emphasize -- use Windows
Authentication! That eliminates the need to hard code user names/passwords.
Security can be implemented and secured based on NT groups.
Steve
- Next message: Shad: "RE: local system question"
- Previous message: Steve Thompson: "Re: local system question"
- In reply to: rick m: "Enterprise manager security?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
