# Dremio data security in open version

**URL:** https://community.dremio.com/t/dremio-data-security-in-open-version/4217
**Category:** Uncategorized
**Created:** [September 30, 2019, 2:43pm UTC](https://community.dremio.com/t/dremio-data-security-in-open-version/4217 "2019-09-30T14:43:16Z")
**Posts on this page:** 6
**Page:** 1

<div class="post-metadata">

### Author: ![Debatri](https://avatars.discourse-cdn.com/v4/letter/d/35a633/32.png) [@Debatri](https://community.dremio.com/u/Debatri)
#### Post date: [September 30, 2019, 2:43pm UTC](https://community.dremio.com/t/dremio-data-security-in-open-version/4217/1 "2019-09-30T14:43:16Z")

</div>

Hi,

Could anyone please tell how much secure the dara we are using in Dremio open source version. As we are using ADLS production data to connect with Query Surge for functional reconciliation.

Thanks,  
Debatri

---

<div class="post-metadata">

### Author: ![balaji.ramaswamy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/balaji.ramaswamy/32/843_2.png) [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)
#### Post date: [October 1, 2019, 1:52pm UTC](https://community.dremio.com/t/dremio-data-security-in-open-version/4217/2 "2019-10-01T13:52:46Z")

</div>

@Debatri

Unfortunately on community edition everybody are administrators and will have access to all datasets. On HDFS though we can lock it via Impersonation

Kindly let us know if you have any other questions

Thanks  
@balaji.ramaswamy

---

<div class="post-metadata">

### Author: ![Debatri](https://avatars.discourse-cdn.com/v4/letter/d/35a633/32.png) [@Debatri](https://community.dremio.com/u/Debatri)
#### Post date: [October 20, 2019, 4:42pm UTC](https://community.dremio.com/t/dremio-data-security-in-open-version/4217/3 "2019-10-20T16:42:03Z")

</div>

Hi Balaji,

Thanks for the info.  
Could you please elaborate on this part you mentioned:  
On HDFS though we can lock it via Impersonation

thanks,  
Dremio

---

<div class="post-metadata">

### Author: ![balaji.ramaswamy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/balaji.ramaswamy/32/843_2.png) [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)
#### Post date: [October 21, 2019, 3:22am UTC](https://community.dremio.com/t/dremio-data-security-in-open-version/4217/4 "2019-10-21T03:22:18Z")

</div>

@Debatri

If impersonation via a Hive source is turned on, then the query would be run as the same user logging into Dremio and only if that user has access on HDFS then he/she can see the data.

Here is a tutorial

> **[How to set up HDFS and HIVE Impersonation](https://www.dremio.com/tutorials/how-to-impersonation/)**
>
> Tutorial that helps users learn how to set up HDFS and HIVE impersonation .

Thanks  
@balaji.ramaswamy

---

<div class="post-metadata">

### Author: ![Debatri](https://avatars.discourse-cdn.com/v4/letter/d/35a633/32.png) [@Debatri](https://community.dremio.com/u/Debatri)
#### Post date: [January 16, 2020, 1:02pm UTC](https://community.dremio.com/t/dremio-data-security-in-open-version/4217/5 "2020-01-16T13:02:41Z")

</div>

Hi Balaji,

Do you have any idea how securely we can connect ADLS to Dremio using open source version of Dremio?

Thanks,  
Debatri

---

<div class="post-metadata">

### Author: ![ben](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/ben/32/1367_2.png) [@ben](https://community.dremio.com/u/ben)
#### Post date: [January 16, 2020, 3:31pm UTC](https://community.dremio.com/t/dremio-data-security-in-open-version/4217/6 "2020-01-16T15:31:18Z")

</div>

Hi @Debatri,

If you mean connect with wire encryption (SSL/TLS) then would have to implement some version of this yourself, as it is only offered in the Enterprise Edition of the software.