Restrict Access to the Database.

[krotha]

Hi
I need to install the database(SqlServer2000) in our client place with only one user account and I don’t want anyone else to view or change the tables, procedures in the database.
Even using a Query Analyzer or Enterprise Manager etc. This is because I want to keep the Database schema not visible to competitors. Kind of trail version, if they agree to buy then will give the full source code. And also I want restrict the physical files, so that they can’t attach to any other database and see it. Any Ideas.

 

[fluteplr]

Its called sql server security look at books online. You are going to have one problem, by default a domain or server admin is going to have access to anything in sql server. I beleive you can remove that access.