sp_select
sp_select copied to clipboard
check minimum permissions
The minimum required permissions for executing the stored procedure should be checked.
- Potentially deploying with execute as self & a check if the code is deployed with a sysadmin account is an option. (although not bullet proof.)
- Could also sign the procedures and map to a login.