Directories and grants
420246Jan 7 2008 — edited Jan 8 2008Dear Experts,
I'm running 10.2.0.3 under W2K. I performed the following test:
- Connect user1/user1@GTEST
- Create or replace directory OUTPUT AS ‘D:\TEST\OUTPUT’
- Perform the creation of a file in OUTPUT using utl_file package inside a procedure.
- Exit
- Connect sys as sysdba
- Revoke read, write on DIRECTORY OUTPUT from user1
- Connect user1/user1@GTEST
- I can still generate the file into the directory OUTPUT calling my procedure. I shouldn't be able to do so , no ?
Have you already experienced this behavior ?
Regards,
Guillaume