I'm working on a simple web viewer for the data contained inside the Progress(9.1D) database and I've run into problems with permissions.
So far I've managed to:
1) Enable the JDBC connection by setting the -Mn parameter for the database
2) Figure out that the DB uses inherited userid from WinXP (administrator)
3) Connect to the DB via SQLExplorer and get the list of tables
Now, I can't get "Permission denied" when trying to select anything from the DB tables, which is odd because the creator-userid should be the owner of the DB right? I tried granting myself some rights via SQLExplorer but that didn't obviously work.
How can I grant myself permissions to read the tables? I didn't find anything useful in the Data Administrator
So far I've managed to:
1) Enable the JDBC connection by setting the -Mn parameter for the database
2) Figure out that the DB uses inherited userid from WinXP (administrator)
3) Connect to the DB via SQLExplorer and get the list of tables
Now, I can't get "Permission denied" when trying to select anything from the DB tables, which is odd because the creator-userid should be the owner of the DB right? I tried granting myself some rights via SQLExplorer but that didn't obviously work.
How can I grant myself permissions to read the tables? I didn't find anything useful in the Data Administrator