Hi,

What you mean by the the same principal? Is it dbo?

I cannot modify the stored procedures but I do see truncate table statements in there. When I grant the user db_datareader, db_datawriter and Alter Schema rights, users are creating tables and leaving the tables inside there even though they should drop it. This is a problem for us.

Is there another way I can grant execute permissions without all these rights, just execute and db_datareader?