Using a superuser role or a role with user creation permissions, connect via cqlsh to a node on the cluster and create a new user for the Foglight Agent as follows:
For versions of Cassandra >= 2.2 or DSE >= 5.0, create a user as follows:
CREATE ROLE IF NOT EXISTS WITH PASSWORD = '' AND LOGIN = true AND SUPERUSER = false;
There are then two ways to set permissions. The simpler way is to use the following single permission:
GRANT SELECT ON ALL KEYSPACES to ;
It is also possible to use more specific permissions:
GRANT SELECT ON TABLE system.local to ;
GRANT SELECT ON TABLE system.peers to ;
GRANT SELECT ON TABLE system_traces.events to ;
GRANT SELECT ON TABLE system_traces.sessions to ;
GRANT SELECT ON TABLE system_auth.roles to ;
Using specific permissions, there is one version-dependent permission. For versions of Cassandra >= 3.0:
GRANT SELECT ON TABLE system_schema.tables to ;
For versions of Cassandra >= 2.2 but less than 3.0:
GRANT SELECT ON TABLE system.schema_columnfamilies to ;
Using the more specific permissions on any version >=2.2 use the following if running DSE:
GRANT SELECT ON TABLE dse_perf.node_slow_log to ;
For versions of Cassandra < 2.2 or DSE
CREATE USER IF NOT EXISTS WITH PASSWORD '' NOSUPERUSER; GRANT SELECT ON ALL KEYSPACES TO ;
© ALL RIGHTS RESERVED. Feedback Nutzungsbedingungen Datenschutz Cookie Preference Center