프로그래밍/MS-SQL
The EXECUTE permission was denied on the object xxxx
노을지기
2024. 10. 15. 23:09
USE [YOUR DATABASE NAME HERE];
GRANT EXEC ON dbo.[YOUR OBJECT NAME HERE] TO PUBLIC
The EXECUTE permission was denied on the object 'xxxxxxx', database 'zzzzzzz', schema 'dbo'
I'm having problems executing a function. Here's what I did: Create a function using SQL Server Management Studio. It was successfully created. I then tried executing the newly created function and
stackoverflow.com