Sparx Systems Forum

Enterprise Architect => General Board => Topic started by: Major Peanut on February 06, 2013, 10:36:59 am

Title: ODBC user - privileges
Post by: Major Peanut on February 06, 2013, 10:36:59 am

Is there an set of recommended ODBC user privileges (e.g. SELECT, CREATE, UPDATE, etc) for connecting to MySQL repository?

Not sure if this is a FAQ or RTFM, but could on find the info.

Thanks - MP

Title: Re: ODBC user - privileges
Post by: RoyC on February 06, 2013, 11:27:53 am

For releases 9 and 10, in the Help integrated with the installer (click on one of the Help icons on the Start Page, Toolbars or dialogs) go to:

Table of Contents > Projects and Teams > Server Based Repositories > Create a Project in a MySQL Database > Connect to a MySQL Data Repository

That topic tells you, at the top, that you need to have SELECT, UPDATE, INSERT and DELETE access permissions.