tags:

views:

103

answers:

1
Q: 

Per user password of a sql ce database.

Is there anyway to password protect a sqlce database, per user?
Say I have two users, Mary and Sally. Mary can only access her info and vis versa. Or would I have to duplicate the database for each user and give each instance it's own password. Thanks.

A: 

No, SQL CE doesn't support any concept of users.

ctacke  2009-05-27 22:04:42

related questions

SQL Compact Problem After Installing on Vista Client
Recommended framework for data aggregation
How to include SQL Compact and .NET Framework in my Installer
Performance in SQL Mobile with one big column that's not being selected
SQL CE Merge Replication: Error 28532: A read operation from the transport returned no data.
Full text search on a mobile device?
convert sdf to mdf
ASP.NET 3.5 Web Application on media support (CD-ROM)
The best way to check if SQL CE is installed, and if so what version?
How to create an SQL Compact 2008 application
What is the number of maximum concurrent connections for Sql CE 3.5?
Can you create a linked server from SQL Server (any version) to a SQL Server CE (3.5) database?
Deleting Sql Ce system tables programmatically?
Profiler for Sql CE
Customizing schema with Sync Framework
Has anyone used (or considered using) Sql Server Compact Edition?
jdbc driver for Microsoft SQL Server CE(Compact Edition) 3.5
SQL Compact select top 1
NHibernate nvarchar/ntext truncation problem
SQL Compact Edition 3.5 SP 1 - LockTimeOutException - how to debug?
Serializing SQL CE data to XML
Database functionality with WPF app: SQLite, SQL CE, other?
Choosing a desktop database
How do you create a foreign key relationship in a SQL Server CE (Compact Edition) Database?
C# WinForms - DataGridView/SQL Compact - Negative integer in primary key column