Munish wrote:prvileges acquired via ROLE do *NOT* apply within named PL/SQL procedures
I am running 8.1.7 db.
I created a directory called IMAGES.
I created synonym for it .
I have a stored proc which when called post the images in the IMAGES directory to the db.
I am getting the following message and I am not sure what privilege am I missing. I believe I gave the user all the priv except any GLOBAL priv.
Here is the error message I get.
ORA-22286: INSUFFICIENT PRIVILEGES ON FILE OR DIRECTORY TO PERFORM GETLENGTH OPERATION
ORA-06512:AT "SYS.DBMS_LOB", LINE 578
ORA-06512: AT "EDUMET.POS