Home » SQL & PL/SQL » SQL & PL/SQL » Can't connect with new user created
Can't connect with new user created [message #681244] Tue, 30 June 2020 03:06 Go to next message
Mark70
Messages: 17
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 Go to previous messageGo to next message
Michel Cadot
Messages: 67370
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

Re: Can't connect with new user created [message #681246 is a reply to message #681245] Tue, 30 June 2020 03:15 Go to previous messageGo to next message
Mark70
Messages: 17
Registered: June 2020
Junior Member
Oracle version is 18c
Re: Can't connect with new user created [message #681248 is a reply to message #681246] Tue, 30 June 2020 04:32 Go to previous messageGo to next message
John Watson
Messages: 8348
Registered: January 2010
Location: Global Village
Senior Member
Were the answers I gave to your previous questions of any value? If not, I shall not waste your time by offering further assistance.
Re: Can't connect with new user created [message #681252 is a reply to message #681248] Tue, 30 June 2020 07:46 Go to previous messageGo to next message
EdStevens
Messages: 1250
Registered: September 2013
Senior Member
https://community.oracle.com/thread/4336894
Re: Can't connect with new user created [message #682010 is a reply to message #681252] Fri, 25 September 2020 03:44 Go to previous messageGo to next message
Mark70
Messages: 17
Registered: June 2020
Junior Member
Thank you to everyone!
Re: Can't connect with new user created [message #682011 is a reply to message #682010] Fri, 25 September 2020 03:45 Go to previous message
John Watson
Messages: 8348
Registered: January 2010
Location: Global Village
Senior Member
So what was the solution?
Previous Topic: Date format with UTC
Next Topic: How to get a substring from a character on
Goto Forum:
  


Current Time: Mon Sep 28 21:17:48 CDT 2020