ora-01720

Problem can be solved by giving privilege with  " WITH GRANT OPTION" ;