Subject | Re: User name SYSDBA |
---|---|
Author | Roman Rokytskyy |
Post date | 2005-08-09T08:15:35Z |
> The question is not whether it can be done at the execution time butThis fits very well the model where role is specified at connect time.
> whether it should be. IIRC, the SQL spec explicitly requires
> permissions to be checked at the prepare time. And it makes a lot of
> sense to me.
However, if we allow to change the role at runtime, we have either to
invalidate all prepared statements or to check the permissions, etc.
So, _if_ we consider Jim's proposal for implementation, then also
permission management should be changed.
Roman