This discussion is archived
3 Replies Latest reply: Mar 20, 2013 11:21 PM by EddyLau RSS

DAC installation -  "Can't authenticate user" error

EddyLau Newbie
Currently Being Moderated
Hi,

I encounter the "Can't authenticate user" error in DAC first setup after installation when it prompt up to ask for setting up administrator id and password.

here's my sql statement to create database schema for dac in oracle database.
grant dba, connect, resource, create view, create session to SSE_ROLE;
create user DEV_DAC identified by "password";
grant DEV_DAC to SSE_ROLE;
grant dba, connect, resource, create view, create session, grant any role to DEV_DAC;

I tried dropping the data schema and create it again but still fail to authenticate.

did I grant enough privileges to the database schema?

Please help.

Thanks,
Eddy
  • 1. Re: DAC installation -  "Can't authenticate user" error
    SunilSharma Expert
    Currently Being Moderated
    EddyLau wrote:
    Hi,

    I encounter the "Can't authenticate user" error in DAC first setup after installation when it prompt up to ask for setting up administrator id and password.

    here's my sql statement to create database schema for dac in oracle database.
    grant dba, connect, resource, create view, create session to SSE_ROLE;
    create user DEV_DAC identified by "password";
    grant DEV_DAC to SSE_ROLE;
    grant dba, connect, resource, create view, create session, grant any role to DEV_DAC;

    I tried dropping the data schema and create it again but still fail to authenticate.

    did I grant enough privileges to the database schema?

    Please help.

    Thanks,
    Eddy
    Login to DEV_DAC using the credentials from SQL Developer or sql
    Then do select * from W_ETL_USER -- here you will see 2 Administrator id's listed
    now run the command Delete From W_ETL_USER
    Now login to dac client with Administrator and pwd which you have set earlier.

    Mark as helpful or correct if it helps

    Thanks,
    RM
  • 2. Re: DAC installation -  "Can't authenticate user" error
    Veeresh Rayan Journeyer
    Currently Being Moderated
    When you login for the first time,did you create authentication file?..

    Regards,
    Veeresh Rayan
  • 3. Re: DAC installation -  "Can't authenticate user" error
    EddyLau Newbie
    Currently Being Moderated
    Hi, RM

    I tried using Administrator/Administrator to log on the DAC client instead of the database schema id. now i can successfully login.


    Thanks a lot.

    Regards,
    Eddy

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points