Friday, March 9, 2012

Need Access-like security of SQL Server Express

Is there a way to implement Access-like password protection on a SQL Server Express dataset?

The database will be deployed on individual's PCs with no centralization of control. I want to restrict users from being able to see table definitions, stored procedures, etc. Access-like password protection is what I want, but I don't see any similar feature within SQL Server Express. Am I missing something?

hi,

at current time SQL Server does not provide this kind of "protection".. you can just encrypt stored procedures/views/user defined functions, you can even encrypt data, but you can not "hide" the database metaschema of the included tables..

regards

No comments:

Post a Comment