Truncate Table permission RRS feed

  • Question

  • i have stored procedure which is executed by a group let say 'Testgroup'.

    in this procedure  i have embedded one "truncate table" statment, i dont want to give any alter or truncate permission to 'Testgroup', how can i achieve this.

    altered proc with

    EXECUTE AS OWNER statment. it worked but later in this proc one Cross database transaction being executed so getting an error like.

    The server principal 'sais not able to access the database 'XYZunder the current security context

    SQL Server DBA

    Friday, January 13, 2017 8:46 AM

All replies