Hi @Bamak Mrbi , welcome to Microsoft Q&A forum.
Please check the below points for queries:
1). Authorized view are basically used to query other tables based on certain permissions. In your case, it seems you want to query separate database on same server. This can be achieved using the Elastic Queries in Azure SQL. These queries will need 'ALTER ANY EXTERNAL DATA SOURCE' to be run. Once we have created the elastic queries, then these can be run using simple t-sql commands. Please refer to below article for more details:
Get started with cross-database queries
2). Materialized view are already part of azure SQL Database, it works exactly similar to how any views works on relational databases. These views query on the current data, so if the underlying data changes these views will return the latest result sets.
3). Through Management Studio or Azure Data Studio, we will not be able to see the users-role mapping, however we can still all the users and roles separately in SSMS. We need to use queries only to get the mapping between them:
Please let us know if this helps or else we can discuss further on the same.
If answer is helpful please click on as it could help other members of the Microsoft Q&A community who have similar questions and are looking for solutions. Thank you for helping to improve Microsoft Q&A!