I have just created a new user on an newly created Oracle 12C database and cannot use it to login from either SQL*Plus or SQL Developer. What am I doing wrong? I can connect as SYSTEM but not as NEWGUY.
-- logged in as SYSTEM....
alter session set CONTAINER=PDBNEW
create user NEWGUY identified by FRED
grant connect to NEWGUY
I can connect as system but trying to connect changing only the username and password results in failure. (ORA-91917: invalid username/password; login denied.
I can see NEWGUY in the DBA_USERS table.
I'll amend this if you need more information....
sessionrather thanconnect, thoughconnectshould still work as far as I'm aware. What is your connect command - do you have the password case correct? - Alex Poolefred(instead ofFRED) as the password during login, you'd get exactly that message. - a_horse_with_no_nameconnect newguy/FRED@pdbnewbut I'm not sure. (I haven't started working with 12c yet but I think you might not be doing that; you know thealter sessionyou did earlier doesn't affect what theconnectis accessing?). - Alex Poole