mercredi 28 janvier 2015

Sql Server 2014 AppRole not able to create temptable in tempdb


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