i'm running progress 9 on rhel 5.0.
Where do i configure that tools accessing the progress database (jdbc / odbc openlink) from outside the server only have a read only connection to the progress database.
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
In progess it is possible with security to pinpoint out which user has access to which table. There is a datadictionairy tool present.
This is also controlled by the menu security of the application.
My question however is that I DONT WANT ANY USER TO CHANGE DATA using the external tools like jdbc/odbc open edge, not the common user and also not the administrator.
well by default users are not allowed to write in the database using odbc/jdbc. So you wont have a problem. The only user who can always write in the database using odbc/jdbc is the creator of the database and sysprogress. You can;t change that. The only thing you can do is make sure that they are no users in the _user table. If they are not in _user then then no one has write access.
Casper.
You can always disallow blank user ID this will force all 4GL users to use a password when connecting to the database. You can do this in the data administration. The users will need to be in the _user table then. (Progress own database security mechanism).
If I am correct then with SQL you will always need to be authorized to connect to the database unless there are no users in hte _user table.
Casper.
Business Accounts
Answer for Membership
by: progressorPosted on 2009-10-07 at 23:27:59ID: 25522693
You must set the SQL permissions per table. I hope you are using SQL92 and not the open interface broker from progress. Because there this wont work.
Basically you log in the database with DBA rights (typically this will be done with user sysprogress and sql explorer. Sysprogress is the default DBA acount and sql explorer is a tool Progress ships with their product to make a jdbc connection to the database,
After logging in you must grant permissions to the users connecting to the progress database using SQL.
If you want to grant a privilige to all then you can grant the permissions to PUBLIC
I hope this helps.
Regards,
casper.
Select allOpen in new window