How to grant the execute permission to User on all the procedure of the database?
-- creating the database role CREATE ROLE Database_Executor -- granting the execute permission to database role GRANT EXECUTE TO Database_Executor -- Here I am granting the SQLDBPool login execute permission USE [DBName] GO CREATE USER [SQLDBPool] FOR LOGIN [sqldbpool] GO USE [DBName] GO EXEC sp_addrolemember N'Database_Executor', N'sqldbpool' GO
No comments:
Post a Comment