question

sumsionjg_26599 avatar image
sumsionjg_26599 asked Lewisr650 answered

Is there a way to disable truncate in Opscenter?

I want to run Opscenter as a read-only view of a database and disable destructive operations.

If there was some flag I could put in the config after I got everything set up that would then reject attempts to modify anything that would be awesome.

Does that sort of thing exist?

opscenter
1 comment
10 |1000

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

pramod.dba31_92912 avatar image pramod.dba31_92912 commented ·

You can create read only user/role from settings menu.

1 Like 1 ·

1 Answer

Lewisr650 avatar image
Lewisr650 answered

Yes, you can do that through role based access controls and remove the ability for a non-superuser to truncate tables. You can learn more about separation of duties in role based access controls here: https://docs.datastax.com/en/security/6.0/security/secPermissions.html

Share
10 |1000

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.