Dree Vasquez (4/14/2013)
What you mean by the the same principal? Is it dbo?
Could be dbo, could be another database principal (owner, not schema)
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.
Creating and dropping user tables inside a procedure? That will be a problem, not to mention being a rather bad practice.
Is there another way I can grant execute permissions without all these rights, just execute and db_datareader?
Again, without seeing the code, I'm guessing. Ownership chaining will mean that you don't need to grant data reader and data writer.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability