How a user of a stored procedure to modify permissions granted to another user? Find didn't find the way for a long time, hope to master give directions!

CodePudding user response:

Grant execute on myproc to target_user

CodePudding user response:

I mean to modify permissions, not execute permissions

CodePudding user response:

reference 1st floor selling fruit net reply:

grant execute on myproc to target_user

webmaster embarrassing, topic main problem very easy to let a person I first soon is also thought to be the execute permissions to somebody else, you actually can repeat three letter may be a little bit better,

CodePudding user response:

reference 3 floor water stop I reply:

webmaster embarrassing, topic main problem very easy to let a person I first soon is also thought to be the execute permissions to somebody else, you actually can repeat three letter may be a little bit better,

Well,

Can grant alter any procedure to the USERNAME to the authority, is a little big, the original poster,