we have created Application Roles in sql server 2014 and grant the "Execute" permission on the tables and stored procedures. when i execute sp_setAppRole and then the stroredprocedure. the simple stored procedure works well. but when i execute the storedprocedure which is creating a temptable. it doesnt work error comes about permission (Access denied).
any idea? how AppRole works with temptable(tempdb)?
Aucun commentaire:
Enregistrer un commentaire