How "sql security" option restrict privileges?
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "wangxu" <[EMAIL PROTECTED]>;
Sent: Wednesday, December 28, 2005 3:21 PM
Subject:Re: how to use "sql security"
> At 1
At 15:17 +0800 12/28/05, wangxu wrote:
User_one create a procdure named "proc" with option "sql security invoker".
User_two only have "execute" privilege in the database that the "proc" in.
But the User_two still call the "proc".
What effect do the "sql security" option producing?
proc runs
User_one create a procdure named "proc" with option "sql security invoker".
User_two only have "execute" privilege in the database that the "proc" in.
But the User_two still call the "proc".
What effect do the "sql security" option producing?
