I have installed Oracle 11g database and created sample schemas like hr, oe etc.

Now I'm unable to access hr schema from different machine and it says insufficient privileges if I try to connect but I'm able to connect sys user from different machine.

I don't know what privilege is missing in hr schema to make it connect from different machine in different IP.

Thanks

SQL> create user demo identified by demo;

User created.

SQL> conn demo/demo
ERROR:
ORA-01045: user DEMO lacks CREATE SESSION privilege; logon denied


Warning: You are no longer connected to ORACLE.
SQL> conn / as sysdba
Connected.

SQL> grant create session to demo;

Grant succeeded.

SQL> conn demo/demo
Connected.