Menu
Is there a way to grant execute permissions for a role or a user using GUI (not T-SQL)? I'm using SQL Server 2008 SP1.
943
Use SQL Server Management StudioExpand Stored Procedures, right-click the procedure to grant permissions on, and then select Properties. From Stored Procedure Properties, select the Permissions page. To grant permissions to a user, database role, or application role, select Search.
OmniDB is an open-source, lightweight SQL GUI that supports MySQL, PostgreSQL, Oracle, and MariaDB and runs on Linux, macOS, and Windows. Despite being free, it boasts many paid GUIs features: syntax highlighting, autocomplete, and debugging.
Btw, db_owner is a database ROLE in SQL Server , not a permission. Or if you want the user to execute all current and future stored procedures and scalar-valued functions: grant execute on schema::dbo to User for a single schema, or just grant execute to User for the whole database.
Once database properties windows is displayed, follow steps 1-4 and press OK.
Using steps A, B you can verify it is creating exactly the expected GRANT EXECUTE TO command.
152
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
