Database Administration (MOSC)

MOSC Banner

Can't connect with new user created

edited Jul 17, 2020 5:01AM in Database Administration (MOSC) 4 commentsAnswered

I've just registered to Oracle Cloud Free Tier.

After logging as ADMIN to SQL Developer Web, I've created a new user by executing the following statements:

CREATE USER MYUSERNEW IDENTIFIED BY "..............";grant create session to MYUSERNEW;grant connect to MYUSERNEW;

After giving logout, I've tried to connect as MYUSERNEW but I get:

An invalid user name or password was supplied.

Could it be that even if I've created a new user, oracle free platform allows to connect only by ADMIN?

Thanks!

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center