2

I am connecting to a third party SQL Anywhere instance and having issues generating an Entity Data Model from an existing database. The connection is working with a basic ODBC connection, but when generating a model I am met with a "Permission denied: you do not have permission to select from "sysuserperm"' error. My question is what permission should I ask to be added to this account so I can generate the model?

The full error message is below:enter image description here

Danny Beckett
  • 20,529
  • 24
  • 107
  • 134
sglantz
  • 2,063
  • 4
  • 20
  • 30
  • Have you had any update in your search? – Corey Adler Feb 13 '13 at 18:04
  • @IronMan84 Not much. Like you said, what I am trying to do might only be allowed for users with DBA permissions. This is because the Sybase designed SQL Anywhere component for .Net was apparently designed to check for all permissions immediately instead of as the permissions are needed. That makes setting up a connection with limited permissions as basically a read only data source nearly impossible. – sglantz Feb 15 '13 at 21:53

1 Answers1

2

Sadly, from what I can find, only the DBA itself is allowed to access that table (and the third party that you're using will undoubtedly not want to make you a DBA...)

The link that I found about that is right here.

Mike Gardner
  • 6,611
  • 5
  • 24
  • 34
Corey Adler
  • 15,897
  • 18
  • 66
  • 80