So should I create a new database with the user ‘renan’ so I can access and perform the operations? Renan Barbosa 1 Sign up using Facebook. The “renan” user id may not be a SQL user — that also depends on the Progress version how this db has been setup. If nothing else has been done the initial SQL dba is the user who created the db. Depending on what version of Progress this is and how this database was setup and created you might also have a “sysprogress” user defined who might be the system DBA user. If a user is a DBA they have all privileges on all objects, at the database level.

Uploader: Daisida
Date Added: 3 December 2012
File Size: 39.55 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 34352
Price: Free* [*Free Regsitration Required]

Post Your Answer Discard By clicking “Post Your Answer”, you acknowledge that you have read our updated terms of serviceprivacy policy and cookie policyand that your continued use of the website is subject to these policies. In an ABL client you can connect to a Progress database as a blank user and query tables without explicitly being given privilege to do so. Renan Barbosa 1 What’s new New posts Openedte resources Latest activity.

After performing the connection to the database, I get the following error message when executing a query to get data: In a SQL client, you can’t. This error is ht000 you that datadirsct database user does not have the required privilege to access the table it was trying to read.

  M7160N VIDEO DRIVER DOWNLOAD

Solved: Error When Load Table Progress Openedge – Microsoft Power BI Community

Opdnedge Registered members Current visitors. This guide is for OE9. So if, for example, you are creating a user for Crystal Reports, you don’t want that user to be a DBA.

I have performed all the processes for installing and configuring the Progress OpenEdge version I configured the DSN with username and password and to access odhc database I created and everything connected correctly.

You must log in or register to reply here.

Email Required, but never shown. After performing the connection to the database, I get the following error message openedve executing a query to o;enedge data:. If a user is a DBA they have all privileges on all objects, at the database level. I have accessed OpenEdge Management to guarantee all permissions for my user as shown below, but I still get this error message.

So should I create a new database with the user ‘renan’ so I can access and perform the operations?

Error When Load Table Progress Openedge

The permissions that you are showing from “data administration” are 4gl permissions. Depending on what version of Progress this is and how this database was setup and created you might also have a “sysprogress” user defined who might be the system DBA user. The 4gl and SQL engines do not share permissions. hh000

It is good practice not to grant users more privilege than they require. Depending on your data and your reporting needs, it might be all of the tables or only a subset.

  BT-DG05A WIN7 DRIVER DOWNLOAD

Post as a guest Name. Resources Latest reviews Search resources.

Sign up using Facebook. If a user is not a DBA their privileges are at the object level and they must be granted privileges individually on each object.

For a better experience, please enable JavaScript in your browser before proceeding. Actually, I had created the database and only then created a new user and assigned the permissions to this user.

logon failed. Details :HY[DataDirect][ODBC Progress OpenEdge Wire Protocol drive

These users and their privileges are stored in the sysdbauth table in the sysprogress schema. Datavirect means they inherit those same privileges on newly-created objects. If nothing else has been done the initial SQL dba is the user who created the db.

Sign up using Email and Password. Thread starter qadvietnam Start date Dec 17, Stack Overflow works best with JavaScript enabled. These users and their privileges are stored in the systabauth, syscolauth, and sysseqauth tables in the sysprogress schema. Forums New posts Search forums.

Multifunction Devices