I have procedure with in the procedure I there is a
Truncate table table name. According to sql server books
on line. If i give execute permission to this procedure to
a user that user should be able to execute this procedure
with out any other permissions on the table. But that’s
not true, it gives error does not have a truncate table
permissions on the table. I know it works fine if I
give "db_ddladmin" permissions on that user.
But I cannot give this permission on the production
database to a normal user.
If anybody has the solution please let me know.
Thanks a millions
610 834 5241