Azure SQL: Newly Created View Remains Inaccessible to Limited Users

Data and Databases
1

In production, a view created by an admin isn’t immediately visible to limited users until a metadata query refresh triggers its appearance. Consider the example below:

-- Admin operations
CREATE VIEW temp_view AS SELECT item FROM inventory;
GRANT SELECT ON temp_view TO guest_user;

-- Guest user query
SELECT * FROM temp_view;
2

hey, im experiencin a similar behaviour. seems like azure caches metadata so changes dont show immediatly. running sp_refreshview worked for me. double chekc user permissions too. its weird but eventually refreshes.