You have to create a SQL user and assign a password. Thread starter qadvietnam Start date Dec 17, 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. Then another user that has sufficient privilege i. Sign up using Email and Password. Hi all, I am using Progress Sign up or log in Sign up using Google.
|Date Added:||12 November 2018|
|File Size:||49.95 Mb|
|Operating Systems:||Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X|
|Price:||Free* [*Free Regsitration Required]|
Error When Load Table Progress Openedge
So if, for example, you are creating a user for Crystal Reports, you don’t want that user to be a DBA. After performing the connection to the database, I get the following error message when executing a query to get data:.
I have accessed OpenEdge Management to guarantee all permissions for my user as shown below, but I still get this error message. I configured the DSN with username and password and to access the database I created and everything connected correctly. Hi all, I am using Progress Depending on your data and your reporting needs, it might be all of the tables or only a subset. ht000
Solved: Error When Load Table Progress Openedge – Microsoft Power BI Community
In datadirectt ABL client you can connect to a Progress database as a blank user and query tables without explicitly being given datarirect to do so. Renan Barbosa 1 The 4gl and SQL engines do not share permissions.
Thread starter qadvietnam Start date Dec 17, Resources Latest reviews Search resources. This guide is for OE9. I have performed all the processes for installing and configuring the Progress OpenEdge version After performing the connection to the database, I get the following error message when executing a query to get data: Sign up using Facebook.
Forums New posts Search forums.
satadirect Read through this KB article for more information: The “renan” user id may not be a SQL user — that also depends on the Progress version how this db has been setup. 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.
This error is telling you that the database user does not have the required privilege to access the table it was trying to read. Members Registered members Current visitors.
If a user is not a DBA their privileges are at the object level and they must be granted privileges individually on each object.
What’s new New posts New resources Latest activity. Then another user that has sufficient privilege i. Actually, I had created the database and only then created a new user and assigned the permissions to this user. If nothing else has been done the initial SQL dba is the user who created the db. You must log in or register datadircet reply here.