I'm using EF 5 with Visual Studio 2012 and SQLAnywhere 16. I'm Trying to create an .edmx file with a user that does not have DBA permission.

When I try to generate the file from the database I get an error stating that the user does not have permission to select from the sysusersperm table. This error halts the entire generation process and does not let me choose from those tables that the users has select permission.

The Sybase support site states that DBA permission is needed to be able to select from that table.

Considering that it should be logical to include in the .edmx files only those entities needed, here are my questions?

How can I generate an .edmx file with a user that does not have DBA permission? If it can't be done... are there any plans to fix this all-or-nothing behavior?

Thanks in advance

asked 21 May '13, 14:40

dperez's gravatar image

dperez
31113
accept rate: 0%

edited 21 May '13, 14:44

Mark%20Culp's gravatar image

Mark Culp
22.6k9129265


What type of user is it - and is it based on the new roles model in SQL Anywhere 16? How was the user created, and with which permissions?

From: http://dcx.sybase.com/index.html#sa160/en/dbreference/sysuserperm-compatibility-view.html

"Each row of the SYSUSERPERM view describes one user ID. You must have the SELECT ANY TABLE system privilege to view data in this view."

The Sybase support site

See: http://dcx.sybase.com/ for the up-to-date SQL Anywhere documentation.

permanent link

answered 27 May '13, 13:47

Jeff%20Albion's gravatar image

Jeff Albion
10.7k171174
accept rate: 24%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×194
×65

question asked: 21 May '13, 14:40

question was seen: 1,565 times

last updated: 27 May '13, 13:47