This content has been marked as final. Show 3 replies
1 person found this helpful
EddyLau wrote:Login to DEV_DAC using the credentials from SQL Developer or sql
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?
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
When you login for the first time,did you create authentication file?..
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.