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: 11
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: 67287
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: 11
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: 8315
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 message
EdStevens
Messages: 1228
Registered: September 2013
Senior Member
https://community.oracle.com/thread/4336894
Previous Topic: PLS-00801: internal error [*** ASSERT at file pdz2.c, line 4788; Illegal access (Text)
Next Topic: Extract substring equal to a 7 digits number (merged)
Goto Forum:
  


Current Time: Thu Aug 06 05:52:07 CDT 2020