Warning: Undefined variable $ub in /home/sgso7sed/public_html/wp-content/plugins/advanced-page-visit-counter/public/class-advanced-page-visit-counter-public.php on line 148

Warning: Undefined variable $ub in /home/sgso7sed/public_html/wp-content/plugins/advanced-page-visit-counter/public/class-advanced-page-visit-counter-public.php on line 160
Grant execute on all stored procedures SQL Server Monitoring • SQL Server

Categories:

The following command effectively gives the user permission to execute ALL stored procedures in the database:


-- create a custom database role
CREATE ROLE db_executor


-- grant EXECUTE permission
GRANT EXECUTE TO db_executor

-- add security account to the role
exec sp_addrolemember 'db_executor', 'YourSecurityAccount'
[/code]

Tags:

Comments are closed