Permission denied for relation pg_shadow (Creating EDMX)

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
ephillipe
Posts: 19
Joined: Tue 11 Aug 2009 14:54
Location: Teresópolis, Brazil

Permission denied for relation pg_shadow (Creating EDMX)

Post by ephillipe » Tue 11 Aug 2009 16:53

When I try create a ADO.NET Entity Data Model, after conect I give this error:

---------------------------
Microsoft Visual Studio
---------------------------
An error occurred while connecting to the database. The database might be unavailable. An exception of type 'System.Data.EntityCommandExecutionException' occurred. The error message is: 'Erro ao executar a definição do comando. Consulte a exceção interna para obter mais detalhes.

The inner exception caught was of type 'Devart.Data.PostgreSql.PgSqlException', with this error message: 'permission denied for relation pg_shadow'.'.
---------------------------
OK
---------------------------

ephillipe
Posts: 19
Joined: Tue 11 Aug 2009 14:54
Location: Teresópolis, Brazil

Post by ephillipe » Tue 11 Aug 2009 19:22

My database is in a shared server, this not in local server.

AndreyR
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by AndreyR » Wed 12 Aug 2009 08:42

Thank you for the report, we will investigate the situation.
As a temporary workaround, I recommend you either to connect via superuser to have the permission
for this table, or to use Devart Entity Developer to generate Devart Entity model.
In this case the problem will not be arised.

ephillipe
Posts: 19
Joined: Tue 11 Aug 2009 14:54
Location: Teresópolis, Brazil

Post by ephillipe » Fri 14 Aug 2009 13:01

AndreyR wrote:Thank you for the report, we will investigate the situation.
As a temporary workaround, I recommend you either to connect via superuser to have the permission
for this table, or to use Devart Entity Developer to generate Devart Entity model.
In this case the problem will not be arised.
Hello,
unfortunally, I cannot login with superuser because server is shared, in web host.

Devart Entity Developer generate standard EDMX files?

AndreyR
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by AndreyR » Fri 14 Aug 2009 14:09

Devart Entity Developer generates a .edml file the structure of which is similar to that of a .edmx file.
There are also some code generation differences.
To try this you can add Devart Entity Model to your project, just like ADO.NET Entity Data Model.

ephillipe
Posts: 19
Joined: Tue 11 Aug 2009 14:54
Location: Teresópolis, Brazil

Post by ephillipe » Fri 14 Aug 2009 16:40

AndreyR wrote:Devart Entity Developer generates a .edml file the structure of which is similar to that of a .edmx file.
There are also some code generation differences.
To try this you can add Devart Entity Model to your project, just like ADO.NET Entity Data Model.
Why "Generate from database" works on "Devart Entity Model" and do not work on Visual Studio? The error refer about denied access at view pg_shadow, but when generate from devart tool, everything works fine.

AndreyR
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by AndreyR » Tue 18 Aug 2009 12:03

We have fixed this problem for Microsoft EDM Wizard. The fix will be included in the nearest build.

ephillipe
Posts: 19
Joined: Tue 11 Aug 2009 14:54
Location: Teresópolis, Brazil

Post by ephillipe » Mon 24 Aug 2009 11:48

AndreyR wrote:We have fixed this problem for Microsoft EDM Wizard. The fix will be included in the nearest build.
Thanks, for it.
Do you known when this build will be released?

Shalex
Site Admin
Posts: 8245
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Tue 25 Aug 2009 08:18

We plan to make a new build next week.

ephillipe
Posts: 19
Joined: Tue 11 Aug 2009 14:54
Location: Teresópolis, Brazil

Post by ephillipe » Sat 29 Aug 2009 14:00

Shalex wrote:We plan to make a new build next week.
Thanks. I'm wainting.

ephillipe
Posts: 19
Joined: Tue 11 Aug 2009 14:54
Location: Teresópolis, Brazil

Post by ephillipe » Fri 04 Sep 2009 02:37

Shalex wrote:We plan to make a new build next week.
The Build is too late. :(
Do you have a date for that?

ephillipe
Posts: 19
Joined: Tue 11 Aug 2009 14:54
Location: Teresópolis, Brazil

Post by ephillipe » Fri 04 Sep 2009 14:32

ephillipe wrote:
Shalex wrote:We plan to make a new build next week.
The Build is too late. :(
Do you have a date for that?
The latest version is 4.55.42 (04-Sep-2009).
Thanks for new version :D

[/quote]

Shalex
Site Admin
Posts: 8245
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Fri 04 Sep 2009 14:40

Welcome!

Post Reply