Author Topic: ODBC user - privileges  (Read 1978 times)

Major Peanut

  • EA Novice
  • *
  • Posts: 6
  • Karma: +0/-0
    • View Profile
ODBC user - privileges
« 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

RoyC

  • EA Administrator
  • EA Practitioner
  • *****
  • Posts: 1297
  • Karma: +21/-4
  • Read The Help!
    • View Profile
Re: ODBC user - privileges
« Reply #1 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.
Best Regards, Roy