sysadmin user creation in cloud sql for sql server

[ReddyN]

We have a process where we need sysadmin user like sa in SQL server. I see sa is disabled in Cloud SQL and also I see sysadmin role is not available in Cloud SQL. I need to know if there any other way we get sysadmin access.
We need to create procedures in master databases for example we have a procedure to create users to access specific DB only. In that SP we have used some system sp like sp_addrolemember, sp_OACreate, sp_OADestroy etc.

When I try to create procedure in master DB, we are getting error that CREATE PROCEDURE permission denied in database master. Can someone let me know how we give access to create procedure and execute it?

Also let me know if we can enable sa user or any other user with sysadmin access.

[robertcarlos]

Hi @ReddyN,

Based on this documentation on SQL Server features unavailable for Cloud SQL:

The sysadmin role and system stored procedures that require it

---

If you want this feature to be available in the future, you may file a feature request. We don't have a specific ETA for this but you can track its progress once the ticket has been created.