Hi All,
I wanted to write an utl_file procedure . I checked in all_tab_privs on grantee and grantor of utl_file . It shows no grants given by system to public and other users. When i logged in from system (admin user) and tried to give grants it throws an error 'un necessary privilleges' . Is my DB designed not to give accept grants for utl_file package even if i give grants from a system user to other users? Please kind your advice.
Queries:
SELECT * FROM ALL_TAB_PRIVS WHERE TABLE_NAME = UTL_FILE' ;
GRANT EXECUTE ON UTL_FILE TO USER1 ;
Regards,
Uday