atikdesai (2/23/2011)
Hi everyone,There is one user who has permission to execute one SP.
In that SP, one table is created in database and finally it is dropped at the end of the SP.
When this user is trying to run this SP he is getting following error.
"CREATE TABLE permission denied in database".
Please help me wth this.
You can sign the procedure with a certificate or key to grant CREATE TABLE within the procedure only, but why are you creating and dropping a 'real' table inside a procedure?
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi