<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<title>Add method to user for execute certain queries only - Feature Requests - Redash Discourse</title>
<meta name="description" content="Hi, is it possible to add a method for less permissions?
Currently, a group has full access to the entire database,
The idea is only to grant access to “certain” queries that the administrator has made,
You usually ha&hellip;">
<meta name="generator" content="Discourse 3.2.0.beta2-dev - https://github.com/discourse/discourse version 83621ccbe797223b48b624b00ef04f24672e1f03">
<link rel="icon" type="image/png" href="https://global.discourse-cdn.com/standard17/uploads/redash1/optimized/1X/01e20869afc0877e3e5aee0f94419b9e9bffa961_2_32x32.ico">
<link rel="apple-touch-icon" type="image/png" href="https://global.discourse-cdn.com/standard17/uploads/redash1/optimized/1X/e1838a8a0c506503a22e0c60e2334374b2895c87_2_180x180.png">
<meta name="theme-color" media="all" content="#ffffff">
<meta name="viewport" content="width=device-width, initial-scale=1.0, minimum-scale=1.0, user-scalable=yes, viewport-fit=cover">
<link rel="canonical" href="https://discuss.redash.io/t/add-method-to-user-for-execute-certain-queries-only/9461" />
<link rel="search" type="application/opensearchdescription+xml" href="https://discuss.redash.io/opensearch.xml" title="Redash Discourse Search">
<link href="https://sjc6.discourse-cdn.com/standard17/stylesheets/color_definitions_base__2_8fd59ae1f286f43b3ff17996df07ea951685249d.css?__ws=discuss.redash.io" media="all" rel="stylesheet" class="light-scheme"/>
<link href="https://sjc6.discourse-cdn.com/standard17/stylesheets/desktop_d86c892d7cd5311243d31a8f11787f4b0342874d.css?__ws=discuss.redash.io" media="all" rel="stylesheet" data-target="desktop" />
<link href="https://sjc6.discourse-cdn.com/standard17/stylesheets/checklist_d86c892d7cd5311243d31a8f11787f4b0342874d.css?__ws=discuss.redash.io" media="all" rel="stylesheet" data-target="checklist" />
<link href="https://sjc6.discourse-cdn.com/standard17/stylesheets/discourse-adplugin_d86c892d7cd5311243d31a8f11787f4b0342874d.css?__ws=discuss.redash.io" media="all" rel="stylesheet" data-target="discourse-adplugin" />
<link href="https://sjc6.discourse-cdn.com/standard17/stylesheets/discourse-akismet_d86c892d7cd5311243d31a8f11787f4b0342874d.css?__ws=discuss.redash.io" media="all" rel="stylesheet" data-target="discourse-akismet" />
<link href="https://sjc6.discourse-cdn.com/standard17/stylesheets/discourse-cakeday_d86c892d7cd5311243d31a8f11787f4b0342874d.css?__ws=discuss.redash.io" media="all" rel="stylesheet" data-target="discourse-cakeday" />
<link href="https://sjc6.discourse-cdn.com/standard17/stylesheets/discourse-chat-integration_d86c892d7cd5311243d31a8f11787f4b0342874d.css?__ws=discuss.redash.io" media="all" rel="stylesheet" data-target="discourse-chat-integration" />
<link href="https://sjc6.discourse-cdn.com/standard17/stylesheets/discourse-details_d86c892d7cd5311243d31a8f11787f4b0342874d.css?__ws=discuss.redash.io" media="all" rel="stylesheet" data-target="discourse-details" />
<link href="https://sjc6.discourse-cdn.com/standard17/stylesheets/discourse-footnote_d86c892d7cd5311243d31a8f11787f4b0342874d.css?__ws=discuss.redash.io" media="all" rel="stylesheet" data-target="discourse-footnote" />
<link href="https://sjc6.discourse-cdn.com/standard17/stylesheets/discourse-lazy-videos_d86c892d7cd5311243d31a8f11787f4b0342874d.css?__ws=discuss.redash.io" media="all" rel="stylesheet" data-target="discourse-lazy-videos" />
<link href="https://sjc6.discourse-cdn.com/standard17/stylesheets/discourse-local-dates_d86c892d7cd5311243d31a8f11787f4b0342874d.css?__ws=discuss.redash.io" media="all" rel="stylesheet" data-target="discourse-local-dates" />
<link href="https://sjc6.discourse-cdn.com/standard17/stylesheets/discourse-narrative-bot_d86c892d7cd5311243d31a8f11787f4b0342874d.css?__ws=discuss.redash.io" media="all" rel="stylesheet" data-target="discourse-narrative-bot" />
<link href="https://sjc6.discourse-cdn.com/standard17/stylesheets/discourse-presence_d86c892d7cd5311243d31a8f11787f4b0342874d.css?__ws=discuss.redash.io" media="all" rel="stylesheet" data-target="discourse-presence" />
<link href="https://sjc6.discourse-cdn.com/standard17/stylesheets/discourse-solved_d86c892d7cd5311243d31a8f11787f4b0342874d.css?__ws=discuss.redash.io" media="all" rel="stylesheet" data-target="discourse-solved" />
<link href="https://sjc6.discourse-cdn.com/standard17/stylesheets/discourse-spoiler-alert_d86c892d7cd5311243d31a8f11787f4b0342874d.css?__ws=discuss.redash.io" media="all" rel="stylesheet" data-target="discourse-spoiler-alert" />
<link href="https://sjc6.discourse-cdn.com/standard17/stylesheets/hosted-site_d86c892d7cd5311243d31a8f11787f4b0342874d.css?__ws=discuss.redash.io" media="all" rel="stylesheet" data-target="hosted-site" />
<link href="https://sjc6.discourse-cdn.com/standard17/stylesheets/poll_d86c892d7cd5311243d31a8f11787f4b0342874d.css?__ws=discuss.redash.io" media="all" rel="stylesheet" data-target="poll" />
<link href="https://sjc6.discourse-cdn.com/standard17/stylesheets/poll_desktop_d86c892d7cd5311243d31a8f11787f4b0342874d.css?__ws=discuss.redash.io" media="all" rel="stylesheet" data-target="poll_desktop" />
<link href="https://sjc6.discourse-cdn.com/standard17/stylesheets/desktop_theme_2_be4cb2b86ec06123c5e974acd20fd933d14b129d.css?__ws=discuss.redash.io" media="all" rel="stylesheet" data-target="desktop_theme" data-theme-id="2" data-theme-name="default"/>
<meta id="data-ga-universal-analytics" data-tracking-code="UA-47088186-6" data-json="{"cookieDomain":"auto"}" data-auto-link-domains="">
<link rel="preload" href="https://global.discourse-cdn.com/standard17/assets/google-universal-analytics-v3-08add7ec997ab472fcd9f821d32ff7caf4b8b9a5de2ec18ca723a040be07a098.gz.js" as="script">
<script defer src="https://global.discourse-cdn.com/standard17/assets/google-universal-analytics-v3-08add7ec997ab472fcd9f821d32ff7caf4b8b9a5de2ec18ca723a040be07a098.gz.js"></script>
<link rel="alternate nofollow" type="application/rss+xml" title="RSS feed of 'Add method to user for execute certain queries only'" href="https://discuss.redash.io/t/add-method-to-user-for-execute-certain-queries-only/9461.rss" />
<meta property="og:site_name" content="Redash Discourse" />
<meta property="og:type" content="website" />
<meta name="twitter:card" content="summary" />
<meta name="twitter:image" content="https://global.discourse-cdn.com/standard17/uploads/redash1/optimized/2X/a/a52e874c8cc20cc61cd94b8b6e7efbf7197a93d5_2_1024x365.png" />
<meta property="og:image" content="https://global.discourse-cdn.com/standard17/uploads/redash1/optimized/2X/a/a52e874c8cc20cc61cd94b8b6e7efbf7197a93d5_2_1024x365.png" />
<meta property="og:url" content="https://discuss.redash.io/t/add-method-to-user-for-execute-certain-queries-only/9461" />
<meta name="twitter:url" content="https://discuss.redash.io/t/add-method-to-user-for-execute-certain-queries-only/9461" />
<meta property="og:title" content="Add method to user for execute certain queries only" />
<meta name="twitter:title" content="Add method to user for execute certain queries only" />
<meta property="og:description" content="Hi, is it possible to add a method for less permissions? Currently, a group has full access to the entire database, The idea is only to grant access to “certain” queries that the administrator has made, You usually have sensitive data in the same database, you have some reports that you need, of course you can add a proxy to encrypt that, But the idea is to be more precise when granting access, Example:" />
<meta name="twitter:description" content="Hi, is it possible to add a method for less permissions? Currently, a group has full access to the entire database, The idea is only to grant access to “certain” queries that the administrator has made, You usually have sensitive data in the same database, you have some reports that you need, of course you can add a proxy to encrypt that, But the idea is to be more precise when granting access, Example:" />
<meta property="og:article:section" content="Feature Requests" />
<meta property="og:article:section:color" content="3AB54A" />
<meta property="og:article:tag" content="feature-request" />
<meta property="article:published_time" content="2021-11-14T17:02:52+00:00" />
<meta property="og:ignore_canonical" content="true" />
</head>
<body class="crawler ">
<header>
<a href="/">
Redash Discourse
</a>
</header>
<div id="main-outlet" class="wrap" role="main">
<div id="topic-title">
<h1>
<a href="/t/add-method-to-user-for-execute-certain-queries-only/9461">Add method to user for execute certain queries only</a>
</h1>
<div class="topic-category" itemscope itemtype="http://schema.org/BreadcrumbList">
<span itemprop="itemListElement" itemscope itemtype="http://schema.org/ListItem">
<a href="https://discuss.redash.io/c/feature-requests/5" class="badge-wrapper bullet" itemprop="item">
<span class='badge-category-bg' style='background-color: #3AB54A'></span>
<span class='badge-category clear-badge'>
<span class='category-name' itemprop='name'>Feature Requests</span>
</span>
</a>
<meta itemprop="position" content="1" />
</span>
</div>
<div class="topic-category">
<div class='discourse-tags list-tags'>
<a href='https://discuss.redash.io/tag/feature-request' class='discourse-tag' rel="tag">feature-request</a>
</div>
</div>
</div>
<div itemscope itemtype='http://schema.org/DiscussionForumPosting'>
<meta itemprop='headline' content='Add method to user for execute certain queries only'>
<meta itemprop='articleSection' content='Feature Requests'>
<meta itemprop='keywords' content='feature-request'>
<div itemprop='publisher' itemscope itemtype="http://schema.org/Organization">
<meta itemprop='name' content='Redash Discourse'>
<div itemprop='logo' itemscope itemtype="http://schema.org/ImageObject">
<meta itemprop='url' content='https://global.discourse-cdn.com/standard17/uploads/redash1/original/1X/c07bc573841e1e4a0013ea3b6fe088a1534228a3.png'>
</div>
</div>
<div id='post_1' class='topic-body crawler-post'>
<div class='crawler-post-meta'>
<span class="creator" itemprop="author" itemscope itemtype="http://schema.org/Person">
<a itemprop="url" href='https://discuss.redash.io/u/sefirosweb'><span itemprop='name'>sefirosweb</span></a>
</span>
<link itemprop="mainEntityOfPage" href="https://discuss.redash.io/t/add-method-to-user-for-execute-certain-queries-only/9461">
<link itemprop="image" href="https://global.discourse-cdn.com/standard17/uploads/redash1/original/2X/a/a52e874c8cc20cc61cd94b8b6e7efbf7197a93d5.png">
<span class="crawler-post-infos">
<time itemprop='datePublished' datetime='2021-11-14T17:02:52Z' class='post-time'>
November 14, 2021, 5:02pm
</time>
<meta itemprop='dateModified' content='2021-11-14T17:02:52Z'>
<span itemprop='position'>1</span>
</span>
</div>
<div class='post' itemprop='articleBody'>
<p>Hi, is it possible to add a method for less permissions?</p>
<p>Currently, a group has full access to the entire database,</p>
<p>The idea is only to grant access to “certain” queries that the administrator has made,</p>
<p>You usually have sensitive data in the same database, you have some reports that you need, of course you can add a proxy to encrypt that,</p>
<p>But the idea is to be more precise when granting access,</p>
<p>Example:<br>
<div class="lightbox-wrapper"><a class="lightbox" href="https://global.discourse-cdn.com/standard17/uploads/redash1/original/2X/a/a52e874c8cc20cc61cd94b8b6e7efbf7197a93d5.png" data-download-href="/uploads/short-url/nzgt6LcUTbUYHahBOqd0MSkPxml.png?dl=1" title="image" rel="noopener nofollow ugc"><img src="https://global.discourse-cdn.com/standard17/uploads/redash1/optimized/2X/a/a52e874c8cc20cc61cd94b8b6e7efbf7197a93d5_2_690x246.png" alt="image" data-base62-sha1="nzgt6LcUTbUYHahBOqd0MSkPxml" width="690" height="246" srcset="https://global.discourse-cdn.com/standard17/uploads/redash1/optimized/2X/a/a52e874c8cc20cc61cd94b8b6e7efbf7197a93d5_2_690x246.png, https://global.discourse-cdn.com/standard17/uploads/redash1/optimized/2X/a/a52e874c8cc20cc61cd94b8b6e7efbf7197a93d5_2_1035x369.png 1.5x, https://global.discourse-cdn.com/standard17/uploads/redash1/optimized/2X/a/a52e874c8cc20cc61cd94b8b6e7efbf7197a93d5_2_1380x492.png 2x" data-small-upload="https://global.discourse-cdn.com/standard17/uploads/redash1/optimized/2X/a/a52e874c8cc20cc61cd94b8b6e7efbf7197a93d5_2_10x10.png"><div class="meta">
<svg class="fa d-icon d-icon-far-image svg-icon" aria-hidden="true"><use href="#far-image"></use></svg><span class="filename">image</span><span class="informations">1763×629 26.5 KB</span><svg class="fa d-icon d-icon-discourse-expand svg-icon" aria-hidden="true"><use href="#discourse-expand"></use></svg>
</div></a></div></p>
</div>
<div itemprop="interactionStatistic" itemscope itemtype="http://schema.org/InteractionCounter">
<meta itemprop="interactionType" content="http://schema.org/LikeAction"/>
<meta itemprop="userInteractionCount" content="0" />
<span class='post-likes'></span>
</div>
<div itemprop="interactionStatistic" itemscope itemtype="http://schema.org/InteractionCounter">
<meta itemprop="interactionType" content="http://schema.org/CommentAction"/>
<meta itemprop="userInteractionCount" content="0" />
</div>
</div>
</div>
</div>
<footer class="container wrap">
<nav class='crawler-nav'>
<ul>
<li itemscope itemtype='http://schema.org/SiteNavigationElement'>
<span itemprop='name'>
<a href='/' itemprop="url">Home </a>
</span>
</li>
<li itemscope itemtype='http://schema.org/SiteNavigationElement'>
<span itemprop='name'>
<a href='/categories' itemprop="url">Categories </a>
</span>
</li>
<li itemscope itemtype='http://schema.org/SiteNavigationElement'>
<span itemprop='name'>
<a href='/guidelines' itemprop="url">FAQ/Guidelines </a>
</span>
</li>
<li itemscope itemtype='http://schema.org/SiteNavigationElement'>
<span itemprop='name'>
<a href='http://redash.io/terms.html' itemprop="url">Terms of Service </a>
</span>
</li>
<li itemscope itemtype='http://schema.org/SiteNavigationElement'>
<span itemprop='name'>
<a href='http://redash.io/privacy.html' itemprop="url">Privacy Policy </a>
</span>
</li>
</ul>
</nav>
<p class='powered-by-link'>Powered by <a href="https://www.discourse.org">Discourse</a>, best viewed with JavaScript enabled</p>
</footer>
</body>
</html>