i created a store proc with 'Set Identity_insert on' in the code. (use dbo role)
then i grant exec permission to a public role user.
if public role user run it, it'll print an error message
"The current user is not the database or object owner of table 'organizations'. Cannot perform SET operation."
what can i do with that?