SQL> create user su identified by secret123;
User created.
SQL> alter user andrey grant connect through su;
User altered.
SQL> connect su[andrey]/secret123;
Connected.