1. 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).

Discussion in 'Database Admin' started by durgaprasad1538, Oct 13, 2017.

  1. durgaprasad1538

    durgaprasad1538 New Member

    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
     
  2.  
  3. Rob Fitzpatrick

    Rob Fitzpatrick ProgressTalk.com Sponsor

    An "authorization failed" error means that the user lacks the required permissions on the table(s) in question.

    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.

    This article, and the articles it links to, should get you going:
    Basic Guide to Defining Progress SQL-92 Database Permissions & Security
    Knowledge Article
     

Share This Page