User permission issues., is there a similar user like sa in CloudSQL (to run DBCC filestats/shrink transaction log files) !

[kenny]

its understood that CloudSQL is a managed service and for secuirty reasons some permissions are forbidden, but what are the alternate options and solutions in-case super privileges are forbidden ? 

• User does not have permissions to monitor logs and or, shrink the  transaction log files etc
• We see, user permissions issues while running DBCC filestats
• how do we manage , what are the options we have and are there any other users in CloudSQL similar to sa ?

[Michael T (Google Cloud Support)]

Hello Kenny,

No, there's no similar user on Cloud SQL similar with service account roles [1], but you can use the finer-grained Identity Access and Management (IAM) roles to manage your Cloud SQL permissions [2]. 

As Cloud SQL doesn't support SUPER privileges, as an alternative, you can use GRANT ALL ON `%`.*.  [3]

[1] https://cloud.google.com/iam/docs/creating-managing-service-accounts

[2] https://cloud.google.com/sql/docs/mysql/project-access-control

[3] https://cloud.google.com/sql/faq#grantall

[kenny]

Hi Michael,

Thanks for reply, but i am looking for Sql server Cloud SQL (MSSQL) not mysql.

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-d...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/d262eea3-eccd-40d8-a0fb-4138af28e6af%40googlegroups.com.

[David (Cloud Platform Support)]

Hello Kenny,

The information Michael provided above about super privileges was meant for Cloud SQL in general and applies to Cloud SQL for SQL server and PostgreSQL as well. This is the correct link for Cloud SQL for SQL server about finer-grained Identity Access and Management (IAM).