Search code examples
oracle-databaseoracle18c

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

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 ?

enter image description here

enter image description here

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

enter image description here

Solution

  • 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.