How to execute SQL Server stored procedure from Looker

A complex query works in Looker SQL Runner but I prefer executing a stored procedure. When I entered exec storedprocedurename I got “The EXECUTE permission was denied on the object storedprocedurename, databasename, schema”. Please advise how to exec a stored procedure from Looker.

Thanks.

0 11 3,861
11 REPLIES 11
Top Labels in this Space
Top Solution Authors