Subject | Stored procedures and rights |
---|---|
Author | Bert Neef |
Post date | 2002-07-01T17:27:33Z |
Hi,
I got a strange problem, one of my stored procedures in a Firebird database
won't execute properly. I get the error that I don't have rights to select
from table Leerlingen. Well the user/role I am using at that moment doesn't
have such rights but I did grant the right to the procedure (grant select
on Leerlingen to Procedure Intekenbaar;). When I log in as sysdba
everything works ok. Any ideas what's going wrong and what I could to fix it?
Thanks in advance,
Bert
I got a strange problem, one of my stored procedures in a Firebird database
won't execute properly. I get the error that I don't have rights to select
from table Leerlingen. Well the user/role I am using at that moment doesn't
have such rights but I did grant the right to the procedure (grant select
on Leerlingen to Procedure Intekenbaar;). When I log in as sysdba
everything works ok. Any ideas what's going wrong and what I could to fix it?
Thanks in advance,
Bert