3 Replies Latest reply: Mar 21, 2013 1:21 AM by cwlau RSS

    DAC installation -  "Can't authenticate user" error

    cwlau
      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
          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
            When you login for the first time,did you create authentication file?..

            Regards,
            Veeresh Rayan
            • 3. Re: DAC installation -  "Can't authenticate user" error
              cwlau
              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