creating a user in ORACLE 18c ORA-04045 error after CONNECT permission granted

Question

Not very familiar with oracle, was trying to practice a bit but reached a wall. I create a user with the following code

 CREATE USER labuser
     IDENTIFIED BY abc123
     DEFAULT TABLESPACE users
     TEMPORARY TABLESPACE temp
     QUOTA 10M on users
     PROFILE default;

And I also GRANTED CONNECT to the user object. but i get an error when trying to login via SQL plus. ive tried to see whats on the web but i cant find something relevant to SYSTEM.LOGONSUCCESS. do i need to grant another permission ?

dropped and retried the create to make sure i was making the local user in samplescdb.

Answer 1

UPDATE - had to execute this command in sql developer.

Grant administer database trigger to labuser;

Thank you Ed for pointing me in the right direction.

Answer 2

When you grant CONNECT Role to the user then you also have to enable it. Quickest way is

ALTER USER labuser DEFAULT ROLE ALL;

In order to enable all roles by default, i.e. enabled at logon.