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.

Report message to a moderator

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: 9088
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:

Report message to a moderator

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.

Report message to a moderator

Previous Topic: audit user activities in database.
Next Topic: ROLES/PRIVS
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 22:00:08 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.