• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

Access Denied(authentication Failed) (7512).

#1
Hi

Today some of the user will connect to our database using SQLlink..
error it is showing access denied.
We not found issue on database they are up and running fine.

Our Progress version very old 9.1d .

Is there any option in Progress where we can provide table access for particular user like oracle and sql server.

Please provide me the details how to grant access to any particular user.
How to check from database end which user has access privileges to tables.

please find below for error...

upload_2017-10-14_0-29-33.png
 

Rob Fitzpatrick

ProgressTalk.com Sponsor
#2
please find below for error...
An "authorization failed" error means that the user lacks the required permissions on the table(s) in question.

Is there any option in Progress where we can provide table access for particular user like oracle and sql server.
Database-level user permissions are stored in the system table sysdbauth. Table-level user permissions (non-DBA users) are stored in the system table systabauth. Both of these tables are in the sysprogress schema, therefore they are only readable by a SQL client, not an ABL client. ABL clients can only read from tables in the PUB schema.

Please provide me the details how to grant access to any particular user.
How to check from database end which user has access privileges to tables.
This article, and the articles it links to, should get you going:
Basic Guide to Defining Progress SQL-92 Database Permissions & Security
Knowledge Article