Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings
Reply
Copper Super Contributor
Posts: 23
Registered: ‎03-20-2009

Mobile Designer Database SQL Permission

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?
Tuned Listener
Posts: 8
Registered: ‎03-10-2009

Re: Mobile Designer Database SQL Permission

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.