DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Function Not Working - Privilege Prob?

  1. #1
    Join Date
    Aug 2000
    Posts
    132
    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.

  2. #2
    Join Date
    Jul 2000
    Posts
    296
    How does the user call the function?
    owner.functionname or functionname?

  3. #3
    Join Date
    Aug 2000
    Posts
    132
    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
  •  


Click Here to Expand Forum to Full Width