-
I created a des_encrypt, des_decrypt function as a DBA user, I granted execute rights to the user - they have execute rights on the functions and the package (DBMS_OBFUSCATION_TOOLKIT) but the user gets an invalid column name when he tries to user the function. Both the functions work as the DBA user. Any thoughts would be appreciated.
-
How does the user call the function?
owner.functionname or functionname?
-
thank you! When I put the owner schema name in front of the function it worked. I wasn't looking for that b/c I have other functions where I don't have to user owner schema.