July 17, 2008 at 11:34 pm
Hi all
We have developed a product using sql server 2005 express/standard as backend.
We are this product selling to various customers.
We dont want to give access to any one to view are modify Tables,SPs and design.
We have developed a MSI file which installs SQL server, runs a sql script to modify SA user and to create new application user names with password
I want to restrict windows authentication. the databases should be only accessed thru Applications.
Please Help to do this.
July 18, 2008 at 2:25 am
Well, the two authentication modes supported by SQL Server are Windows and Mixed (both Windows and SQL). So these are your choices :). You can of course play with the permissions. However, even then you will not be able to prevent people modifying your schema. The database files are on their computers, they can access the physical file (so they now have full control over the schema!)
Regards,
Andras
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply