Configuring User Permissions for SQL Server Management Studio

I would like to set up a login user in SQL Server Management Studio to run a stored procedure, but not to change it or view the source code of the procedure. Which role should I set and change?
Please let me know.

sql-server

2022-09-30 21:43

1 Answers

To grant users permission to execute a specific stored procedure.

GRANT EXECUTE ON dbo.procname TO username;

To create a role with execution privileges.

CREATE ROLE ROLENAME;
GRANT EXECUTE TO ROLLENAME;
ALTER ROLE ROLENAME ADD MEMBER username;

2022-09-30 21:43

If you have any answers or tips

Popular Tags

python x 4647

android x 1593

java x 1494

javascript x 1427

c x 927

c++ x 878

ruby-on-rails x 696

php x 692

python3 x 685

html x 656