Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Grant execute on sproc doesn't grant privilege to update? RE: Grant execute on sproc doesn't grant privilege to update?

  • October 31, 2014 at 9:29 am

    #1756062

    ok it looks like I have to keep this in the same schema, I can't update a table of another schema in a stored procedure not of the same schema. Is this always going to be the case with SQL server, or is there some permission I can give to a login which would give it enough permission to bypass this?