Home Forums SQL Server 2008 SQL Server 2008 High Availability Access that can allow to execute SP (create object), however not allow to create/drop/alter table from query window RE: Access that can allow to execute SP (create object), however not allow to create/drop/alter table from query window

  • There are two ways you can achieve this (they can be combined into one):

    EXECUTE AS clause:

    http://msdn.microsoft.com/en-us/library/ms178106.aspx

    Module signing:

    http://msdn.microsoft.com/en-us/library/ms178106.aspx

    Have a look at the above links and post further on this thread with any additional questions.

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]