No RESOURCE priviledges

[Thomas Mercer-Hursh]

I am experimenting with using an OpenEdge database as a repository for EA.  For any other Progress types out there, I am writing up instructions at http://www.oehive.org/node/952 which are a bit more detailed than the ones on the Sparx website or in the Sparx help files.

Thus far, I *appear* to have succeeded and am in the process of exporting the source project to XMI so that I can use the Compare tool.  

The one reason I say "appear" is that when the transfer from the source project was complete, I got a series of errors which all said:

Microsoft OLE DB Provider for ODBC Drivers [-2147467259]
[DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]No RESOURCE privileges (7574)

From the error number, it sounds like it was trying to create a table or sequence and didn't have permission, but not only does the user I connected with have RESOURCE privilege, but I would have thought that the schema was already set up from running the SQL script.

Any ideas?  

[Geert Bellekens]

We had a similar issue with the setup of our Oracle repository.
Apparently it creates sequences on the fly when creating the first project in the repository.
We needed a user with more privileges to be able to connect to Oracle.
You should find some other topics about similar issues in this forum.

[Thomas Mercer-Hursh]

I'm not finding anything searching on RESOURCE.

[Gary W.]

Thomas,

It think it's the one at http://www.sparxsystems.com.au/cgi-bin/yabb/YaBB.pl?board=suggestions;action=display;num=1143120887

hth
gary

[Thomas Mercer-Hursh]

Yes, I found that eventually, but there doesn't seem to be an OpenEdge version of GRANT CREATE SEQUENCES.  

[Thomas Mercer-Hursh]

In that thread, there seemed to be a suggestion that one could eliminate the problem by creating the sequences in advance, but I don't know what sequences to create.

OpenEdge seems to provide GRANT [SELECT|UPDATE] ON SEQUENCE schema.sequence TO username  but not GRANT CREATE SEQUENCES