SYS > connect USR_ODI/Test#2023
ERROR:
ORA-01035: ORACLE only available to users with RESTRICTED SESSION privilege
Warning: You are no longer connected to ORACLE.
SYS> grant RESTRICTED SESSION to USR_ODI;
Grant succeeded.
SYS@> connect USR_ODI/Test#2023
Connected.
USR_ODI >
SYS > connect USR_ODI/Test#2023
ERROR:
ORA-01035: ORACLE only available to users with RESTRICTED SESSION privilege
Warning: You are no longer connected to ORACLE.
SYS> grant RESTRICTED SESSION to USR_ODI;
Grant succeeded.
SYS@> connect USR_ODI/Test#2023
Connected.
USR_ODI >