1. connect with sqlplus with dba rights
2. create a simple user and give password:
sqlplus / as sysdba
2. create a simple user and give password:
create user test identified by test;3. Give some grants to newly created user, like create session, and select
grant CREATE SESSION to test;
grant SELECT ANY TABLE to test;
:)