hiding/password Protecting Enterprise Manager

I have installed SQL 2000 and Enterprise Manager. I have a .Net application
I am developing. I need Enterprise Manager to make data table changes as I
finish my application, but I am afraid my test and final users will use the
Enterprise Manager to change data. I do not want users to change data
without using my application. Can I limit Enterprise Manager or password
protect or block access to other users?
Thanks
Paul DeWitt
Paul DeWitt wrote:
> I have installed SQL 2000 and Enterprise Manager. I have a .Net
> application I am developing. I need Enterprise Manager to make data
> table changes as I finish my application, but I am afraid my test and
> final users will use the Enterprise Manager to change data. I do not
> want users to change data without using my application. Can I limit
> Enterprise Manager or password protect or block access to other users?
> Thanks
> Paul DeWitt
Users can only perform operations that they have security to perform. If
you don't grant access to the tables and use stored procedures to change
and select data, then users logging into the database using any tool
(SQL Enterprise Manager, Query Analyzer, ISQL, OSQL, etc.) will not be
able to change any data unless they call the stored procedures from
those apps. If you do not provide some underlying security in the
database or your users have dbo or admin rights in the database, there
is nothing to prevent them from changing data and nothing you can really
do to stop it, short of encrypting yourself in the application.
David Gugick
Quest Software
www.imceda.com
www.quest.com
|||Check out application roles (sp_setapprole).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Paul DeWitt" <PaulDeWitt@.discussions.microsoft.com> wrote in message
news:E0B9510C-7A3A-4EBB-8EA7-A202FC715D1E@.microsoft.com...
>I have installed SQL 2000 and Enterprise Manager. I have a .Net application
> I am developing. I need Enterprise Manager to make data table changes as I
> finish my application, but I am afraid my test and final users will use the
> Enterprise Manager to change data. I do not want users to change data
> without using my application. Can I limit Enterprise Manager or password
> protect or block access to other users?
> Thanks
> Paul DeWitt