Mobile Designer Database SQL Permission

[ikeyser]

What SQL permission is required for the Mobile Designer database.  In a restricted environment, we only have db_DataWriter and db_DataReader permission to the database and I can't access any of the tables when I open Mobile Architect.  What other permission do we need to access the tables and is there documentation on this that I can provide the dba's so we can get the proper access?

[pwallace]

Ingrid,

Generally, the designer database is intended to be used by a developer in either a local SQL or SQLExpress instance.   As such, generally db_owner rights are required.    If you need to lock the database down, you would need to allow db_spaccess in addition to the permissions you have already granted.