| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: Trouble with stored proc
"Ian Chalcraft" <iac_at_smcewan.demon.co.uk-nospam> wrote:
>The problem here is to do with grants given via a role.
>If you have been granted select on ORG.SOMETABLE
>via a role, then you may NOT access it through a
>stored procedure; you will have to grant select on the
>table explicitly to the procedure's owner.
>This also applies to triggers.
That's exactly the reason, but that's absolutely brain-dead, isn't it? Why on earth should there be a difference between receiving the select right directly vs. receiving it through a role?
Marc
 |
 |