NOTE: This article is an INTERNAL article and is not visible to customers, currently. Please only link this article in internal comments, but not public comments.
Issue
Environment
- Oracle 19c
Resolution
- While working with the EXTENDED max string size value database, user creation in the respective container following this document is not allowing the created user to login through sqldeveloper with ORA-01017. To make it work properly, we need to use the CONTAINER clause.
create user LR_OWNER identified by LR_OWNER CONTAINER=ALL;
grant create session to LR_OWNER CONTAINER=ALL;
grant all privileges to LR_OWNER CONTAINER=ALL;