This right is optional and even taking a database backup during upgrade is optional, so if you DBA is concerned with space you can ask your DBA to take the backup and not grant this right.
------------------------------
Thanks & Regards
Suman Pramanik
Senior Principal Support Engineer | Agile Operations Division
Broadcom Software
------------------------------
Original Message:
Sent: Jan 28, 2025 01:52 PM
From: Wilson Cardenas
Subject: Grant Create ANY DIRECTORY.!!!!
Hello Suman, thank you for responding, the dba is really asking me about the impact at the space or performance level of the Oracle database. some article or reference to put the client at ease.
Original Message:
Sent: Jan 28, 2025 12:31 PM
From: Suman Pramanik
Subject: Grant Create ANY DIRECTORY.!!!!
To permit the upgrade to make automatic backups, grant the application database schema user the CREATE ANY DIRECTORY permission and SELECT permission on DBA_DATAPUMP_JOBS. Here is the document
------------------------------
Thanks & Regards
Suman Pramanik
Senior Principal Support Engineer | Agile Operations Division
Broadcom Software
Original Message:
Sent: Jan 28, 2025 12:19 PM
From: Wilson Cardenas
Subject: Grant Create ANY DIRECTORY.!!!!
Hello community, I hope you are doing very well, we are currently going to update clarity to version 16.2.3, it is under an Oracle database, currently the DBA is asking us for clarification on the grant CREATE ANY DIRECTORY permission, we know exactly what it does as to whether it modifies something in the database, some estimated weight or size, please some official article that can show the customer that it will not affect anything. I really appreciate your wisdom.