I have 2 users: oracle (dba) user and other (staff) user which has permission on Oracle
What happens is that when login to local schema as oracle user for sqlplus, for example, do not need to attach SID; e.g. sqlplus user/passw
but for the other user I have; e.g. sqlplus user/passw@sid
All the ENV vars are set up correctly for the staff user, listener is up so what could be the problem?
Thanks