Hi,
I am working with Oracle RDBMS 19c.
I can create an Oracle Scheduler job for another session when at session level I set current_schema=<username>.
If I well understood, this alter session command places a user in a different schema making it easier to access the objects in this schema without having to qualify the object with the actual schema name.
This method does not change the current user and also does not give any privileges that this new schema has.
This is fine if as user SYSTEM I want to create a job for <username>.
Does someone know if there is a way to achieve this result without gving a password?
Kind Regards