Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 database Security

Author  Topic 

FredFlint
Starting Member

9 Posts

Posted - 2005-09-15 : 10:40:39
Hi all,

I am working on an application used to display and manipulate data stored in a SQL Server 2000 database using Delphi 7 enterprise and ADO. The application is now been sold to several companies that will connect using remote desktop to the same database. I need to make it so that if someone connects to the database using enterprise manager, they can not see any data, but the application must still be able to retrieve data. At the moment dynamic sql and stored procedure are been used by the app. The connection string is using windows authentication + sql server. If someone could give me any pointers, links … that would be good as I have no experience with the security side of things.

FredFlint

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-09-15 : 10:55:43
See if this helps you
http://sqlsecurity.com/DesktopDefault.aspx

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -