Permission denied for relation pg_shadow (Creating EDMX)

Permission denied for relation pg_shadow (Creating EDMX)

Postby 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

Postby ephillipe » Tue 11 Aug 2009 19:22

My database is in a shared server, this not in local server.
ephillipe
 
Posts: 19
Joined: Tue 11 Aug 2009 14:54
Location: Teresópolis, Brazil

Postby 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.
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Postby 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?
ephillipe
 
Posts: 19
Joined: Tue 11 Aug 2009 14:54
Location: Teresópolis, Brazil

Postby 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.
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Postby 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.
ephillipe
 
Posts: 19
Joined: Tue 11 Aug 2009 14:54
Location: Teresópolis, Brazil

Postby 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.
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Postby 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?
ephillipe
 
Posts: 19
Joined: Tue 11 Aug 2009 14:54
Location: Teresópolis, Brazil

Postby Shalex » Tue 25 Aug 2009 08:18

We plan to make a new build next week.
Shalex
Devart Team
 
Posts: 7792
Joined: Thu 14 Aug 2008 12:44

Postby 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

Postby 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

Postby 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]
ephillipe
 
Posts: 19
Joined: Tue 11 Aug 2009 14:54
Location: Teresópolis, Brazil

Postby Shalex » Fri 04 Sep 2009 14:40

Welcome!
Shalex
Devart Team
 
Posts: 7792
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for PostgreSQL