Implement finer-grained control of REST-API users. Initial requirement is to be able to restrict the REST-API access only to the query editor.
For the SQL endpoint in particular, certain extra limits should be added:
Add per-user result size limits or add global size limit parameter in the maxscale.cnf file
Original description:
View access only on GUI query editor for few users
Implement a feature only GUI view access for query editor tab and hide all the rest of the dashboard GUI. We want to give only query editor GUI to only specific users and rest of the dashboard (Monitoring, logs, user management and etc) tabs should be hide.
What about read-only(basic) users?
The only difference from what you're asking for is that they can access other pages but can't modify them. We can hide the "Users" page for the basic users as it makes no sense for them to see it, but other pages will still be visible. Overall, they can see but can't modify.
Thien Ly
added a comment - What about read-only(basic) users?
The only difference from what you're asking for is that they can access other pages but can't modify them. We can hide the "Users" page for the basic users as it makes no sense for them to see it, but other pages will still be visible. Overall, they can see but can't modify.
Yeah, but we are giving this to other teams, they should not see all the ip's, log data and hostnames. For security point of view at the same time quick access. I mean the page directly redirect to Query Editor.
Give some customize option for admin default and other we will select options like what we can give view access.
Naresh Chandra
added a comment - Yeah, but we are giving this to other teams, they should not see all the ip's, log data and hostnames. For security point of view at the same time quick access. I mean the page directly redirect to Query Editor.
Give some customize option for admin default and other we will select options like what we can give view access.
People
Unassigned
Naresh Chandra
Votes:
0Vote for this issue
Watchers:
3Start watching this issue
Dates
Created:
Updated:
Git Integration
Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.
{"report":{"fcp":773.8999998569489,"ttfb":228.09999990463257,"pageVisibility":"visible","entityId":116073,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"d970c778-ed6a-4d03-a3c1-9f755adc24a1","navigationType":0,"readyForUser":843.1999998092651,"redirectCount":0,"resourceLoadedEnd":956.6999998092651,"resourceLoadedStart":249.59999990463257,"resourceTiming":[{"duration":68.40000009536743,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":249.59999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":249.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":318,"responseStart":0,"secureConnectionStart":0},{"duration":68.59999990463257,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2cib/820016/12ta74/494e4c556ecbb29f90a3d3b4f09cb99c/_/download/contextbatch/css/jira.browse.project,project.issue.navigator,jira.view.issue,jira.general,jira.global,atl.general,-_super/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true&whisper-enabled=true","startTime":250.09999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":250.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":318.69999980926514,"responseStart":0,"secureConnectionStart":0},{"duration":114.29999995231628,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":250.29999995231628,"connectEnd":250.29999995231628,"connectStart":250.29999995231628,"domainLookupEnd":250.29999995231628,"domainLookupStart":250.29999995231628,"fetchStart":250.29999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":250.29999995231628,"responseEnd":364.59999990463257,"responseStart":364.59999990463257,"secureConnectionStart":250.29999995231628},{"duration":132,"initiatorType":"script","name":"https://jira.mariadb.org/s/2d8175ec2fa4c816e8023260bd8c1786-CDN/lu2cib/820016/12ta74/494e4c556ecbb29f90a3d3b4f09cb99c/_/download/contextbatch/js/jira.browse.project,project.issue.navigator,jira.view.issue,jira.general,jira.global,atl.general,-_super/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en&slack-enabled=true&whisper-enabled=true","startTime":250.89999985694885,"connectEnd":250.89999985694885,"connectStart":250.89999985694885,"domainLookupEnd":250.89999985694885,"domainLookupStart":250.89999985694885,"fetchStart":250.89999985694885,"redirectEnd":0,"redirectStart":0,"requestStart":323.5,"responseEnd":382.89999985694885,"responseStart":336,"secureConnectionStart":250.89999985694885},{"duration":72.40000009536743,"initiatorType":"script","name":"https://jira.mariadb.org/s/a9324d6758d385eb45c462685ad88f1d-CDN/lu2cib/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":251.09999990463257,"connectEnd":251.09999990463257,"connectStart":251.09999990463257,"domainLookupEnd":251.09999990463257,"domainLookupStart":251.09999990463257,"fetchStart":251.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":251.09999990463257,"responseEnd":323.5,"responseStart":323.5,"secureConnectionStart":251.09999990463257},{"duration":115.30000019073486,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":251.19999980926514,"connectEnd":251.19999980926514,"connectStart":251.19999980926514,"domainLookupEnd":251.19999980926514,"domainLookupStart":251.19999980926514,"fetchStart":251.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":251.19999980926514,"responseEnd":366.5,"responseStart":366.5,"secureConnectionStart":251.19999980926514},{"duration":74.60000014305115,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":251.39999985694885,"connectEnd":251.39999985694885,"connectStart":251.39999985694885,"domainLookupEnd":251.39999985694885,"domainLookupStart":251.39999985694885,"fetchStart":251.39999985694885,"redirectEnd":0,"redirectStart":0,"requestStart":251.39999985694885,"responseEnd":326,"responseStart":326,"secureConnectionStart":251.39999985694885},{"duration":73.79999995231628,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2cib/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":251.59999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":251.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":325.39999985694885,"responseStart":0,"secureConnectionStart":0},{"duration":158.70000004768372,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":251.69999980926514,"connectEnd":367.09999990463257,"connectStart":367.09999990463257,"domainLookupEnd":367.09999990463257,"domainLookupStart":367.09999990463257,"fetchStart":251.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":367.39999985694885,"responseEnd":410.39999985694885,"responseStart":409.19999980926514,"secureConnectionStart":367.09999990463257},{"duration":120.90000009536743,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2cib/820016/12ta74/d176f0986478cc64f24226b3d20c140d/_/download/contextbatch/css/com.atlassian.jira.projects.sidebar.init,-_super,-project.issue.navigator,-jira.view.issue/batch.css?jira.create.linked.issue=true","startTime":251.89999985694885,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":251.89999985694885,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":372.7999999523163,"responseStart":0,"secureConnectionStart":0},{"duration":115.29999995231628,"initiatorType":"script","name":"https://jira.mariadb.org/s/5d5e8fe91fbc506585e83ea3b62ccc4b-CDN/lu2cib/820016/12ta74/d176f0986478cc64f24226b3d20c140d/_/download/contextbatch/js/com.atlassian.jira.projects.sidebar.init,-_super,-project.issue.navigator,-jira.view.issue/batch.js?jira.create.linked.issue=true&locale=en","startTime":252,"connectEnd":252,"connectStart":252,"domainLookupEnd":252,"domainLookupStart":252,"fetchStart":252,"redirectEnd":0,"redirectStart":0,"requestStart":252,"responseEnd":367.2999999523163,"responseStart":367.2999999523163,"secureConnectionStart":252},{"duration":643.7999999523163,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":267,"connectEnd":267,"connectStart":267,"domainLookupEnd":267,"domainLookupStart":267,"fetchStart":267,"redirectEnd":0,"redirectStart":0,"requestStart":267,"responseEnd":910.7999999523163,"responseStart":910.7999999523163,"secureConnectionStart":267},{"duration":638.3999998569489,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":271.5,"connectEnd":271.5,"connectStart":271.5,"domainLookupEnd":271.5,"domainLookupStart":271.5,"fetchStart":271.5,"redirectEnd":0,"redirectStart":0,"requestStart":271.5,"responseEnd":909.8999998569489,"responseStart":909.8999998569489,"secureConnectionStart":271.5},{"duration":318.90000009536743,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":591.3999998569489,"connectEnd":591.3999998569489,"connectStart":591.3999998569489,"domainLookupEnd":591.3999998569489,"domainLookupStart":591.3999998569489,"fetchStart":591.3999998569489,"redirectEnd":0,"redirectStart":0,"requestStart":591.3999998569489,"responseEnd":910.2999999523163,"responseStart":910.2999999523163,"secureConnectionStart":591.3999998569489},{"duration":150,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":767.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":767.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":917.5,"responseStart":0,"secureConnectionStart":0},{"duration":42.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/e65b778d185daf5aee24936755b43da6/_/download/contextbatch/js/browser-metrics-plugin.contrib,-_super,-project.issue.navigator,-jira.view.issue,-atl.general/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true&whisper-enabled=true","startTime":914.1999998092651,"connectEnd":914.1999998092651,"connectStart":914.1999998092651,"domainLookupEnd":914.1999998092651,"domainLookupStart":914.1999998092651,"fetchStart":914.1999998092651,"redirectEnd":0,"redirectStart":0,"requestStart":914.1999998092651,"responseEnd":956.6999998092651,"responseStart":956.6999998092651,"secureConnectionStart":914.1999998092651}],"fetchStart":0,"domainLookupStart":20,"domainLookupEnd":27,"connectStart":29,"connectEnd":49,"secureConnectionStart":38,"requestStart":50,"responseStart":228,"responseEnd":271,"domLoading":231,"domInteractive":998,"domContentLoadedEventStart":998,"domContentLoadedEventEnd":1037,"domComplete":1133,"loadEventStart":1133,"loadEventEnd":1134,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":975.2999999523163},{"name":"bigPipe.sidebar-id.end","time":976.2999999523163},{"name":"bigPipe.activity-panel-pipe-id.start","time":976.3999998569489},{"name":"bigPipe.activity-panel-pipe-id.end","time":977.5},{"name":"activityTabFullyLoaded","time":1050.3999998569489}],"measures":[],"correlationId":"61235816ffb2c4","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":92,"dbReadsTimeInMs":9,"dbConnsTimeInMs":20,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
New Feature
Major
MXS-5317 No limit option enabled
What about read-only(basic) users?
The only difference from what you're asking for is that they can access other pages but can't modify them. We can hide the "Users" page for the basic users as it makes no sense for them to see it, but other pages will still be visible. Overall, they can see but can't modify.