IDEA/SUGGESTION: Is it possible to support ownership chaining for stored procedure in synapse.

Question

Synapse product group confirmed that ownership chain is not supported in synapse, thus i was wondering if it is possible to support this feature in the further. Thank you for your attention.

Here is the example for your reference
If I used the server admin to create a view and a store procedure:

CREATE VIEW dbo.PV1
AS
SELECT * FROM [Sales].[Customer] ------ this is for different schema

CREATE PROCEDURE dbo.PP1
AS
SELECT * FROM [Sales].[Customer] ------ this is for different schema

Then grant the below permission on another user:

GRANT SELECT ON OBJECT::dbo.PV1 TO PTest

GRANT EXECUTE ON OBJECT::dbo.PP1 TO PTest

Then login with that user and execute the below script:

SELECT * FROM [dbo].[PV1] ----- working

EXEC dbo.PP1 ----- doesn't work, failed with permission errors: The SELECT permission was denied on the object 'CUSTOMER', database 'NA', schema 'SALES'.

Answer 1

Hello @Keevey Song ,

I just heard from the internal team and they confirmed that they do have plans to imlement this in future . I am unable to share any tenatative dates at thsi time .

Thanks
Himanshu