Now what you could do is to write a proc which does it then ties it to a certificate which has the access.

This is similar to how you can give...

Permissions to the DMV's are detailed on their respective documentation page.

sys.database_principals

Permissions
Any user can see their own user name, the system users, and the fixed database roles. To...

Probably allows the use of old legacy ciphers / algorithms, but just clutching at straws there, unsure of the internals.

We can only go on what the public documentation says.

Might be...

You could just do a straight select also, no need to convert the hex to the GUID as it will implicitly do this for you

SELECT...

Are you sending via O365? SQL 2016 and below don't have DotNet set to use strong ciphers, and O365 says you need it.

There's a few things you need to change...

Check the database mail log and verify the email is being sent to the queue, the queue is active and that there are no errors.

select * from...

Use an older version instead unfortunately.

As per the documentation, 20.2 is only tested on 2014 and above.

https://learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver16#supported-sql-offerings

You could just do a straight select also, no need to convert the hex to the GUID as it will implicitly do this for you

SELECT * FROM...

Probably best you join the Slack community and post in the #dbatools channel

https://dbatools.io/slack

A lot of the DBATools folks hang out there instead.

So whats in the trace file?  Does it help us understand whats happening in some way?

sp_send_dbmail is not available on Azure SQL DB, so you will need to use some 3rd party application which can integrate with your application to send mail on it's behalf,...

Maybe one to post on an actual Oracle forum also.

Everyone here will be primarily Microsoft SQL Server focused, not to say that there may not be a few Oracle people...

Yeah SQLAgent can't work without MSDB so if MSDB is missing, then quite rightly so would SQL Agent.

Have you checked from sys.master_files the path to MSDB?

Have you check that those...

You'll need some app / query logic to prevent it.

IF EXISTS(SELECT 1 FROM #unique_names WHERE email = @email AND first IS NOT '' AND last IS NOT...

Use powershell and integrate with the Azure (AZ) module to make the Azure backend responsible for doing the restore for you.

You have picked a PaaS offering, let Microsoft do all...