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
sean.massey
SSC Veteran
Points: 219
More actions
February 24, 2011 at 9:15 pm
#1291352
Hi,
I can't for the life of me remember the term for doing this but if you grant the stored proc create, insert, update, etc then don't provide the users with any of those rights except execute on the stored proc that should do it for you.