I have set of users who monitor environment performance and want graphs that are in MC. I created Database read only user and given privileges MC configuration- IT and MC's Database Access=Associate. However the user is still able to start/stop nodes. Can this privilege be restricted?
MC privileges
+2
+2Hmm. According to the doc, only the MC role "ADMIN" should have the ability to "Start/stop a node":
+2unfortunately even associate role has
+2Verify what GRANTS the DB user has...
select grantor, privileges_description, object_schema, object_name, object_type from grants where grantee = '<<USER_NAME>>';
+2the user has only read privilege on some tables. i gave DB user sysmonitor privilege since user need to run reports
+2grantor privileges_description object_schema object_name object_type
dbadmin USAGE (null) general RESOURCEPOOL
dbadmin (null) test_RO ROLE
dbadmin USAGE (null) public SCHEMA
dbadmin SELECT public v_dcalloc_pool_stat_by_second VIEW
dbadmin USAGE (null) test SCHEMA
dbadmin (null) sysmonitor ROLE
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
