I need a way to lock a SQL Server Express database that is deployed to a PC, which may or may not be on a domain.
I would like to ensure that the end user cannot access the database aside from a highly restricted access via stored procedures, even if they put the system on their domain, and are a domain administrator, because tampering with the data would present data integrity concerns.
I could secure an administrative credentials for the sa user. However I would like to establish credentials for only 1 user that only has visibility and ability to execute stored procedures which are already created. Additionally the user has no read/query access to the actual tables or actual data in the tables.
Is there any way to do what I need using SQL Server Express? Or, is there a different FREE database that could accomplish this (that has the same 'power' as SQL Server Express)?