go to post Sebastian Thiele · Mar 15, 2016 Hi,i did usesGRANT EXECUTE ON SCHEMA MySchema ON WebApp-User,WebApp-Adminunfortunatly this doesn´t work. Tells me that reserved word SCHEMA was found. Does the hypen (-) in the role names could also be a problem?best regards,sebastian
go to post Sebastian Thiele · Mar 14, 2016 Hi, sry for the late response. I´ve managed to setup the application, roles and priveliges as suggested. My application does use a set of (currently) 20 stored procedures to fetch data from the server. The problem now is that the webapp-admin and webapp-user have no permission to run this stored procedures. I thought it would be sufficient to add the db ressource to the roles to access this stored procedures. Does this mean, that I need to add every single stored procedure to the sql procedure tab in the role definition?best regards,sebastian
