March 17, 2011 at 2:02 am
hi everybody,
i have one application using sql server 2008 . i want to set password at database level. not in server level or for user sa. because i distribute my application to client and they have information about sa password and if they want they can see my table structure and i want that in this database my application can only use . how is it possible
i want to give all the permission to client . but they don't able to see my structure.
March 17, 2011 at 6:18 am
Can't be done. If you put a database on a client's server, they have full and complete control over it.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 6, 2011 at 1:47 pm
You can use an application role to limit permissions inside the database to an application, but that does not alleviate some type of login, and as Gail mentioned, it does not prevent anyone from seeing your table structure.
Note if you think your table structure is somehow intellectual property and worth protecting to keep secret, you would be wrong.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply