# Global Temporary Tables

**URL:** https://discuss.elastic.co/t/global-temporary-tables/267228
**Category:** Elasticsearch
**Created:** [March 15, 2021, 8:31am UTC](https://discuss.elastic.co/t/global-temporary-tables/267228 "2021-03-15T08:31:06Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![onkark](https://avatars.discourse-cdn.com/v4/letter/o/bbce88/32.png) [@onkark](https://discuss.elastic.co/u/onkark)
#### Post date: [March 15, 2021, 8:31am UTC](https://discuss.elastic.co/t/global-temporary-tables/267228/1 "2021-03-15T08:31:06Z")

</div>

Is there something like global temporary tables/session tables we can use  
in elasticsearch ?  
The info about global temp tables can be looked here [ORACLE-BASE - Global Temporary Tables](https://oracle-base.com/articles/misc/temporary-tables).

Thanks in advance..!

---

<div class="post-metadata">

### Author: ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)
#### Post date: [March 15, 2021, 11:30am UTC](https://discuss.elastic.co/t/global-temporary-tables/267228/2 "2021-03-15T11:30:45Z")

</div>

What's the use case?

---

<div class="post-metadata">

### Author: ![onkark](https://avatars.discourse-cdn.com/v4/letter/o/bbce88/32.png) [@onkark](https://discuss.elastic.co/u/onkark)
#### Post date: [March 17, 2021, 11:11am UTC](https://discuss.elastic.co/t/global-temporary-tables/267228/3 "2021-03-17T11:11:14Z")

</div>

Thanks for your reply.  
I have a WebAPI in which multiple users hit request at same time. Each user has its own connection to access data from elasticsearch and each user must able to access  
only his own data from respective index, where the index name needs to be same for each user. So, I need to make indexes to be shared with the multiple users at the  
same time with each user able to access only his respective data.

---

<div class="post-metadata">

### Author: ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)
#### Post date: [March 17, 2021, 1:03pm UTC](https://discuss.elastic.co/t/global-temporary-tables/267228/4 "2021-03-17T13:03:31Z")

</div>

Have a look at filtered aliases.

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)
#### Post date: [April 14, 2021, 1:04pm UTC](https://discuss.elastic.co/t/global-temporary-tables/267228/5 "2021-04-14T13:04:12Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.