We are delighted to announce the general availability of Database Scoped Global Temporary Tables for Azure SQL DB. Similar to global temporary tables for SQL Server (tables prefixed with ##table_name), global temporary tables for Azure SQL DB are stored in tempdb and follow the same semantics.
However, rather than being shared across all databases on the server, they are scoped to a specific database and are shared among all users’ sessions within that same database. User sessions from other Azure SQL databases cannot access global temporary tables created as part of running sessions connected to a given database. Any user can create global temporary objects.