I'm working on an Oracle 11g database, and simply need to create a user and log in with it. I successfully create the user, but after running the second line below, I still can't log in. Is there something I'm missing?
create user "oskar" identified by "oskar_pass"; grant create session to "oskar"; select * from DBA_USERS; --oskar is there, but can't log in
(I tired "grant connect" as well, to no avail.)