Re: [google-cloud-sql-discuss] Re: User permission issues., is there a similar user like sa in CloudSQL (to run DBCC filestats/shrink transaction log files) !

Hi Michael,

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

On Tue, Feb 18, 2020 at 7:18 AM 'Michael T (Google Cloud Support)' via Google Cloud SQL discuss <google-cloud-sql-discuss@googlegroups.com> wrote:

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

On Monday, February 17, 2020 at 3:32:56 AM UTC-5, kenny wrote:

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 ?

--
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-discuss+unsubscribe@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.

--
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-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/CAEx6%2B%3DH%2BHNwUnm-fUGvEuWh_agty0uaTpR-kjxbxLLoBHAYddg%40mail.gmail.com.