Dear Friends
Whenever I am trying to create a new Users System is not showing any error , but after Creating the user I try to connect it shows the error ORA-01017: invalid username/password; logon denied ,
SQL> create user erp identified by erp;
User created.
SQL> grant connect, resource to erp;
Grant succeeded.
SQL> grant imp_full_database to erp;
Grant succeeded.
SQL> commit;
Commit complete.
SQL> grant exp_full_database to erp;
Grant succeeded.
SQL> commit;
Commit complete.
SQL> connect
Enter user-name: erp
Enter password:
ERROR:
ORA-01017: invalid username/password; logon denied
Warning: You are no longer connected to ORACLE.
SQL>
sanjay