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