Home » RDBMS Server » Security » Problem defining role
Problem defining role [message #6239] Sat, 05 April 2003 02:32 Go to next message
Shahinur Rahman
Messages: 10
Registered: September 2002
Junior Member
Hi

I have created a role and defined necessary permission to this role including connect permission. i have also given permission to execute the database function. example :

grant execute on fn_voucher_no to test;

permission is granted but when i go to run the form (in developer 6i) it does not recognise the function name (fn_voucher).

please help me to solve this problem.
Re: Problem defining role [message #6242 is a reply to message #6239] Sat, 05 April 2003 03:15 Go to previous messageGo to next message
Barbara Boehmer
Messages: 8922
Registered: November 2002
Location: California, USA
Senior Member
Privileges to execute procedures and functions must be granted directly, not through roles. Please click on the link below for Tom Kyte's explanation:

Thanks Barbara Boehmer [message #6244 is a reply to message #6239] Sat, 05 April 2003 03:26 Go to previous message
Shahinur Rahman
Messages: 10
Registered: September 2002
Junior Member
Thank you very much for helping me. i have granted the permission directly and its working.
Previous Topic: audit user activities in database.
Next Topic: ROLES/PRIVS
Goto Forum:
  


Current Time: Thu Sep 23 17:02:52 CDT 2021