Hi!
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
I can't figure out what I am missing when trying to get RAS demo's to work.
1st the user is created in rasadm hrdemo_setup.sql
...clipeticlips
-- Create two application users:
-- DAUSTIN (in IT department), granted EMP_ROLE and IT_ROLE.
exec xs_principal.create_user(name => 'daustin', schema => 'hr');
exec sys.xs_principal.set_password('daustin', 'welcome1');
exec xs_principal.grant_roles('daustin', 'emp_role');
exec xs_principal.grant_roles('daustin', 'it_role');
...clipeticlips
2nd the hrdemo_run.sql has conn
...clipeticlips
----------------------------------------------------------------------
-- HR Demo (run-time)
----------------------------------------------------------------------
-- Connect as DAUSTIN, who has only EMP_ROLE and IT_ROLE
conn daustin/welcome1;
..clipeticlips
But that throws in sqldeveloper:
ORA-01045: user DAUSTIN lacks CREATE SESSION privilege; logon denied
or in sqlplus
SYS @ CDB:> conn daustin/welcome1;
ERROR:
ORA-01017: invalid username/password; logon denied
And can't figure out how to define the user and its grants so that the conn works
SYS @ CDB:> history 3 run
grant create session to daustin
*
ERROR at line 1:
ORA-01917: user or role 'DAUSTIN' does not exist
Actually this same conn problem applies if I carefully follow the https://www.youtube.com/watch?v=Cwro1pzgE24&feature=youtu.be
Where to look?
What I am potentialy missing?
rgrds Paavo