ORA-29289: directory access denied / Why this difference in behavior ?
Hi experts,
If I create a user with read, write grants on a directory, it's ok.
But if I create a user, a role, grant read write on directory to the role and grant role to this user, acces directory is denied ?
Test case :
Case 1 :
sqlplus "/@PDBCGAN as sysdba"
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Feb 23 17:04:24 2023
Version 19.17.0.0.0
Copyright (c) 1982, 2022, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0 - Production
Version 19.17.0.0.0
SQL> CREATE USER syslna IDENTIFIED BY "syslna";
User created.
SQL> GRANT CREATE SESSION TO syslna;
Grant succeeded.
SQL> GRANT CREATE PROCEDURE TO syslna;
Grant succeeded.
0