• I think you can re-write the sp

    include a variable that will accept schema name. and grant permission for the users using the particular schema to access the object user.

    variable.user must give the answer i guess.

    [font="Comic Sans MS"]+++BLADE+++[/font]:cool: