Subject | Re: Execute Statement fpr Vulcan |
---|---|
Author | Roman Rokytskyy |
Post date | 2005-04-21T16:15:52Z |
> No, that's not right. The statements should be checked by the agentI would add ".. unless another agent is specified."
> who tries to execute it.
I believe that it is quite common that one can specify a principal,
under which the call is executed (see for example createProcessAsUser
call in Windows). However such feature should require new grant:
GRANT UPGRADE PERMISSION [ON PROCEDURE <proc name>] TO {<object> |
<userList>}
Initially this permission is granted to the database owner, but he can
delegate it to any user by using WITH GRANT OPTION modifier.
Do we want this feature? Personally I see no need in it, but that's
another issue.
Roman