-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|