Can't connect with new user created [message #681244] |
Tue, 30 June 2020 03:06 |
|
Mark70
Messages: 18 Registered: June 2020
|
Junior Member |
|
|
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!
|
|
|
Re: Can't connect with new user created [message #681245 is a reply to message #681244] |
Tue, 30 June 2020 03:11 |
|
Michel Cadot
Messages: 68665 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Michel Cadot wrote on Mon, 22 June 2020 16:53
Michel Cadot wrote on Wed, 10 June 2020 12:25
From your previous topic:
Michel Cadot wrote on Thu, 04 June 2020 16:42
With any SQL or PL/SQL question, please, Post a working Test case: create table (including all constraints) and insert statements along with the result you want with these data then we will be able work with your table and data. Explain with words and sentences the rules that lead to this result.
And as asked in your previous topic:
Michel Cadot wrote on Wed, 03 June 2020 17:58...
Note: Always post your Oracle version, with 4 decimals (query v$version), as often solution depends on it.
A feedback in this topic would also be welcome.
And the other one too.
And the other oneS too, now.
[Updated on: Tue, 30 June 2020 08:40] Report message to a moderator
|
|
|
|
|
|
|
|