# Security

**URL:** https://www.singlestore.com/forum/c/support/security/25.md

[Latest](https://www.singlestore.com/forum/latest.md) · [Categories](https://www.singlestore.com/forum/categories.md) · [Tags](https://www.singlestore.com/forum/tags.md)

---

## [About the Security category](https://www.singlestore.com/forum/t/about-the-security-category/54)

<div class="topic-metadata">

**Author:** [@memsqlpubs](https://www.singlestore.com/forum/u/memsqlpubs)\
**Replies:** 0

</div>

---

## [Jwks\_username\_field variable not working as intended](https://www.singlestore.com/forum/t/jwks-username-field-variable-not-working-as-intended/7328)

<div class="topic-metadata">

**Author:** [@daotuan1903](https://www.singlestore.com/forum/u/daotuan1903)\
**Replies:** 1\
**Last updated:** [December 21, 2023, 10:38am UTC](https://www.singlestore.com/forum/t/jwks-username-field-variable-not-working-as-intended/7328 "2023-12-21T10:38:22Z")

</div>

I am working on an experiment on localhost with JWT Authentication. I set the ‘jwks\_endpoint’ and ‘jwks\_username\_field’ as mentioned in the docs. (The picture below shows my current config) I can retrieve tokens fro…

---

## [Optimising SingleStore](https://www.singlestore.com/forum/t/optimising-singlestore/7239)

<div class="topic-metadata">

**Author:** [@heychazza](https://www.singlestore.com/forum/u/heychazza)\
**Replies:** 1\
**Last updated:** [October 19, 2023, 11:26pm UTC](https://www.singlestore.com/forum/t/optimising-singlestore/7239 "2023-10-19T23:26:30Z")

</div>

Hi folks, After running a report I’ve been given the following: Primarily my eyes are drawn to the following: ✓ consistentMaxMemory ........................... \[PASS\] NOTE Inconsistent maximum\_memory values for aggre…

---

## [\`sync\_permissions\` Enabled By Default, Any Way to Completely Disable?](https://www.singlestore.com/forum/t/sync-permissions-enabled-by-default-any-way-to-completely-disable/6827)

<div class="topic-metadata">

**Author:** [@ymonye](https://www.singlestore.com/forum/u/ymonye)\
**Replies:** 3\
**Last updated:** [July 12, 2023, 12:43pm UTC](https://www.singlestore.com/forum/t/sync-permissions-enabled-by-default-any-way-to-completely-disable/6827 "2023-07-12T12:43:59Z")

</div>

Hey all, Reading through the docs, it appears once sync\_permissions is enabled then it’s a permanent change. The only problem is this variable appears to have been enabled by default when installing a fresh copy of Sing…

---

## [Sync\_permission command understanding for nodes upgrades](https://www.singlestore.com/forum/t/sync-permission-command-understanding-for-nodes-upgrades/6914)

<div class="topic-metadata">

**Author:** [@sebaZ](https://www.singlestore.com/forum/u/sebaZ)\
**Replies:** 1\
**Last updated:** [June 27, 2023, 6:33pm UTC](https://www.singlestore.com/forum/t/sync-permission-command-understanding-for-nodes-upgrades/6914 "2023-06-27T18:33:15Z")

</div>

Hi folks! I have a singlestore cluster with 2 nodes. Master/Leaf - Agregator/Leaf. Now, I need to perform an memory update on nodes, so I wanted to use promote command. I realize that users are not in both nodes, and I…

---

## [BACKUP DATABASE is not permitted on child aggregators](https://www.singlestore.com/forum/t/backup-database-is-not-permitted-on-child-aggregators/6785)

<div class="topic-metadata">

**Author:** [@DataSleek](https://www.singlestore.com/forum/u/DataSleek)\
**Replies:** 1\
**Last updated:** [May 17, 2023, 5:38am UTC](https://www.singlestore.com/forum/t/backup-database-is-not-permitted-on-child-aggregators/6785 "2023-05-17T05:38:33Z")

</div>

Running Singlestore CIAB (Cluster in a box) on Ubuntu. Trying to backup DB to S3 and I’m getting: This instance is not the master aggregator. BACKUP DATABASE is not permitted on child aggregators without SYNC\_PERMISSIO…

---

## [SingleStore LDAP Authentication Errors](https://www.singlestore.com/forum/t/singlestore-ldap-authentication-errors/5376)

<div class="topic-metadata">

**Author:** [@adrshen](https://www.singlestore.com/forum/u/adrshen)\
**Replies:** 5\
**Last updated:** [April 8, 2023, 8:12am UTC](https://www.singlestore.com/forum/t/singlestore-ldap-authentication-errors/5376 "2023-04-08T08:12:06Z")

</div>

Hi Folks, I followed help article to enable and sync up AD group in my test of environment. The tool got configured and ran successfully. It pulled up all the users and then created them on destination SingleStore clust…

---

## [How to alter the user password](https://www.singlestore.com/forum/t/how-to-alter-the-user-password/1845)

<div class="topic-metadata">

**Author:** [@rjsv](https://www.singlestore.com/forum/u/rjsv)\
**Replies:** 3\
**Last updated:** [March 28, 2023, 7:26am UTC](https://www.singlestore.com/forum/t/how-to-alter-the-user-password/1845 "2023-03-28T07:26:54Z")

</div>

I have created a user as below. CREATE USER ‘admin1’@’%’ IDENTIFIED BY ‘raojsv!123’; When I tried to change the password using below command,I am facing the issue. Please guide me how to proceed. ALTER USER admin1 ID…

---

## [Tracelog error (checked on master aggregator failed because the 2PC transaction)](https://www.singlestore.com/forum/t/tracelog-error-checked-on-master-aggregator-failed-because-the-2pc-transaction/6384)

<div class="topic-metadata">

**Author:** [@srikar](https://www.singlestore.com/forum/u/srikar)\
**Replies:** 1\
**Last updated:** [January 11, 2023, 1:31am UTC](https://www.singlestore.com/forum/t/tracelog-error-checked-on-master-aggregator-failed-because-the-2pc-transaction/6384 "2023-01-11T01:31:00Z")

</div>

Hello all, can someone let me know what is the below error means NFO: Prepared transaction with id XXXXXXXXXXXXXXX:3846 checked on master aggregator failed because the 2PC transaction has not yet committed or rolled ba…

---

## [GRANT File write & Outbound](https://www.singlestore.com/forum/t/grant-file-write-outbound/5558)

<div class="topic-metadata">

**Author:** [@mitch](https://www.singlestore.com/forum/u/mitch)\
**Replies:** 2\
**Last updated:** [September 26, 2022, 3:29pm UTC](https://www.singlestore.com/forum/t/grant-file-write-outbound/5558 "2022-09-26T15:29:51Z")

</div>

Hi, I am trying to grant FILE WRITE and OUTBOUND privileges to a user on my Singlestore cluster. The GRANT query I am executing is: GRANT FILE WRITE, OUTBOUND ON \`the\_database\`.\`\*\` TO 'user1'@'%' I am executing the a…

---

## [How to hide/encrypt data base table names](https://www.singlestore.com/forum/t/how-to-hide-encrypt-data-base-table-names/5015)

<div class="topic-metadata">

**Author:** [@seshir2020](https://www.singlestore.com/forum/u/seshir2020)\
**Replies:** 1\
**Last updated:** [September 8, 2022, 2:42pm UTC](https://www.singlestore.com/forum/t/how-to-hide-encrypt-data-base-table-names/5015 "2022-09-08T14:42:07Z")

</div>

Hi,I wanted to hide/encrypt database table names from show command from security perspective. Looking forward for some help inthis regard.

---

## [Anonymus DB DROP Commands](https://www.singlestore.com/forum/t/anonymus-db-drop-commands/4944)

<div class="topic-metadata">

**Author:** [@seshir2020](https://www.singlestore.com/forum/u/seshir2020)\
**Replies:** 2\
**Last updated:** [September 1, 2022, 12:02am UTC](https://www.singlestore.com/forum/t/anonymus-db-drop-commands/4944 "2022-09-01T00:02:17Z")

</div>

Hi, I am getting DROP table commands and not able to capture the IP Source.Can some one help me how to capture Source IP and user ID if I Receive any such command

---

## [SSL Encryption For Kafka Pipelines](https://www.singlestore.com/forum/t/ssl-encryption-for-kafka-pipelines/1959)

<div class="topic-metadata">

**Author:** [@Abhinav](https://www.singlestore.com/forum/u/Abhinav)\
**Replies:** 2\
**Last updated:** [July 7, 2022, 7:51pm UTC](https://www.singlestore.com/forum/t/ssl-encryption-for-kafka-pipelines/1959 "2022-07-07T19:51:30Z")

</div>

For enabling SSL encryption (only) for Kafka pipelines, we created the pipeline like below: CREATE PIPELINE \`kafka\_ssl\` AS LOAD DATA KAFKA '\<kafka-host\>:\<kafka-port\>/test' CONFIG '{"security.protocol": "ssl" "ssl.ca.loc…

---

## [TLS 1.0/ 1.1 support](https://www.singlestore.com/forum/t/tls-1-0-1-1-support/4422)

<div class="topic-metadata">

**Author:** [@aaron1](https://www.singlestore.com/forum/u/aaron1)\
**Replies:** 3\
**Last updated:** [April 28, 2022, 9:09pm UTC](https://www.singlestore.com/forum/t/tls-1-0-1-1-support/4422 "2022-04-28T21:09:47Z")

</div>

I am not experienced with SingleStore, so I apologize for the question. I gather from the forums that TLS versions prior to 1.2 are supported. Are TLS versions 1.0 and 1.1 still officially supported? If so, are there…

---

## [Encryption outside Singlestore DB and Descryption inside singlestore](https://www.singlestore.com/forum/t/encryption-outside-singlestore-db-and-descryption-inside-singlestore/4298)

<div class="topic-metadata">

**Author:** [@baskar.sks](https://www.singlestore.com/forum/u/baskar.sks)\
**Replies:** 5\
**Last updated:** [March 28, 2022, 3:54pm UTC](https://www.singlestore.com/forum/t/encryption-outside-singlestore-db-and-descryption-inside-singlestore/4298 "2022-03-28T15:54:12Z")

</div>

Hi, I am syncing Data from Oracle DB to Singlestore for reporting thru Kafka. There are a few fields which needs to be encrypted before sending to Kafka. So trying to encrypt the field using AES128 bit encryption method…

---

## [Hide or change name of connect](https://www.singlestore.com/forum/t/hide-or-change-name-of-connect/4102)

<div class="topic-metadata">

**Author:** [@soportesh](https://www.singlestore.com/forum/u/soportesh)\
**Replies:** 1\
**Last updated:** [March 2, 2022, 7:01pm UTC](https://www.singlestore.com/forum/t/hide-or-change-name-of-connect/4102 "2022-03-02T19:01:17Z")

</div>

Hi Teams SingleStore Please I need your help. The security Area IT, asks me how to hide or change name the url connect (http://ippublic:8080/connect). Or can you rename “connect” with another name? Thanks

---

## [Do call api and view confidential data](https://www.singlestore.com/forum/t/do-call-api-and-view-confidential-data/4101)

<div class="topic-metadata">

**Author:** [@soportesh](https://www.singlestore.com/forum/u/soportesh)\
**Replies:** 2\
**Last updated:** [February 28, 2022, 12:37pm UTC](https://www.singlestore.com/forum/t/do-call-api-and-view-confidential-data/4101 "2022-02-28T12:37:17Z")

</div>

Hi Teams SingleStore Please I need your help. The security Area IT, asks me to hide the api url, for example http://ippublic:8080/api/clusters This web address shows sensitive information.

---

## [Support AES 256 GCM](https://www.singlestore.com/forum/t/support-aes-256-gcm/3795)

<div class="topic-metadata">

**Author:** [@baskar.sks](https://www.singlestore.com/forum/u/baskar.sks)\
**Replies:** 1\
**Last updated:** [February 7, 2022, 7:29pm UTC](https://www.singlestore.com/forum/t/support-aes-256-gcm/3795 "2022-02-07T19:29:33Z")

</div>

Singlestore supports AES 128 encryption with ECB mode. Is there any plan to support AES 256 with GCM mode? Any ETA for this?

---

## [Create database INTO S3 Permissions](https://www.singlestore.com/forum/t/create-database-into-s3-permissions/3770)

<div class="topic-metadata">

**Author:** [@franck.leveneur](https://www.singlestore.com/forum/u/franck.leveneur)\
**Replies:** 1\
**Last updated:** [January 27, 2022, 9:30pm UTC](https://www.singlestore.com/forum/t/create-database-into-s3-permissions/3770 "2022-01-27T21:30:40Z")

</div>

What are the S3 required permission to use S3 as database storage (i.e. : create database into S3 …) Would this be enough? “Action”: \[ “s3:PutObject”, “s3:GetObject”, “s3:ListBucket” \]

---

## [Https SingleStoreDB Studio](https://www.singlestore.com/forum/t/https-singlestoredb-studio/3321)

<div class="topic-metadata">

**Author:** [@jonathan.arana](https://www.singlestore.com/forum/u/jonathan.arana)\
**Replies:** 1\
**Last updated:** [September 18, 2021, 1:00am UTC](https://www.singlestore.com/forum/t/https-singlestoredb-studio/3321 "2021-09-18T01:00:55Z")

</div>

Hello, is there a way to install an ssl certificate for singlestoredb studio? To be able to login via https

---

## [How to clean up the Sleep Session?](https://www.singlestore.com/forum/t/how-to-clean-up-the-sleep-session/3149)

<div class="topic-metadata">

**Author:** [@kyoungho.kum](https://www.singlestore.com/forum/u/kyoungho.kum)\
**Replies:** 2\
**Last updated:** [July 19, 2021, 12:38am UTC](https://www.singlestore.com/forum/t/how-to-clean-up-the-sleep-session/3149 "2021-07-19T00:38:36Z")

</div>

Hi, all SingleStoreDB does not use the interactive\_timeout, wait\_timeout two variables to clean up the Sleep Session. There doesn’t seem to be a variable to replace them in SingleStoreDB. If you have a good method or …

---

## [Securing SingleStore DB: Authentication and Administration](https://www.singlestore.com/forum/t/securing-singlestore-db-authentication-and-administration/3101)

<div class="topic-metadata">

**Author:** [@jlb](https://www.singlestore.com/forum/u/jlb)\
**Replies:** 11\
**Last updated:** [July 6, 2021, 5:53pm UTC](https://www.singlestore.com/forum/t/securing-singlestore-db-authentication-and-administration/3101 "2021-07-06T17:53:27Z")

</div>

Hi. I have completed the course ’ \[Running Developer Labs in Docker\]’ (Loading) All went well and four containers are running. I then started the course ‘Securing SingleStore DB: Authentication and Administration’ I …

---

## [Change Secure\_File\_Priv](https://www.singlestore.com/forum/t/change-secure-file-priv/2988)

<div class="topic-metadata">

**Author:** [@anish](https://www.singlestore.com/forum/u/anish)\
**Replies:** 2\
**Last updated:** [May 15, 2021, 4:53am UTC](https://www.singlestore.com/forum/t/change-secure-file-priv/2988 "2021-05-15T04:53:01Z")

</div>

how to change the default settings of “Secure\_File\_Priv” after the node configuration .

---

## [Exporter password in clear text on the command line](https://www.singlestore.com/forum/t/exporter-password-in-clear-text-on-the-command-line/2857)

<div class="topic-metadata">

**Author:** [@celer-tech](https://www.singlestore.com/forum/u/celer-tech)\
**Replies:** 1\
**Last updated:** [March 29, 2021, 5:16pm UTC](https://www.singlestore.com/forum/t/exporter-password-in-clear-text-on-the-command-line/2857 "2021-03-29T17:16:51Z")

</div>

The memsql exporter user/password can be seen easily as they are part of the command line. This should be changed to be better hidden. A simple ps -ef can show the credentials: memsql\_exporter --config.user= --config.p…

---

## [(Newbie Q) Usage granted to ROLE - but can't revoke it?](https://www.singlestore.com/forum/t/newbie-q-usage-granted-to-role-but-cant-revoke-it/2714)

<div class="topic-metadata">

**Author:** [@ctaylor](https://www.singlestore.com/forum/u/ctaylor)\
**Replies:** 2\
**Last updated:** [January 27, 2021, 1:20pm UTC](https://www.singlestore.com/forum/t/newbie-q-usage-granted-to-role-but-cant-revoke-it/2714 "2021-01-27T13:20:15Z")

</div>

I’m a newbie to administering memSQL and we’re running 7.1.4 I made a couple of mistakes (on grants) and am trying to reverse the grant (revoke) but the revoke doesn’t seem to work. Here’s the grant: GRANT USAGE ON \`d…

---

## [Hacked - No Backup](https://www.singlestore.com/forum/t/hacked-no-backup/2270)

<div class="topic-metadata">

**Author:** [@DataSleek](https://www.singlestore.com/forum/u/DataSleek)\
**Replies:** 1\
**Last updated:** [August 19, 2020, 6:37pm UTC](https://www.singlestore.com/forum/t/hacked-no-backup/2270 "2020-08-19T18:37:56Z")

</div>

Hi, Our MemSQL Dev cluster was hacked. All schemas dropped, new WARNING table created asking for bitcoin to get the table. Looking a memsql.log looks like it was done via SQL injection. Unfortunately i don’t have a re…

---

## [Is there any function to parse the IPV6 ips](https://www.singlestore.com/forum/t/is-there-any-function-to-parse-the-ipv6-ips/1866)

<div class="topic-metadata">

**Author:** [@rjsv](https://www.singlestore.com/forum/u/rjsv)\
**Replies:** 8\
**Last updated:** [June 22, 2020, 6:58pm UTC](https://www.singlestore.com/forum/t/is-there-any-function-to-parse-the-ipv6-ips/1866 "2020-06-22T18:58:51Z")

</div>

We are using MemSQL v7.0. Do you have any function to parse IPV6 ips like INET\_ATON function. Is there any mechanism to parse IPV6 ips in Memsql V 7.0?

---

## [Row Level Security Feature](https://www.singlestore.com/forum/t/row-level-security-feature/1969)

<div class="topic-metadata">

**Author:** [@mosganian](https://www.singlestore.com/forum/u/mosganian)\
**Replies:** 1\
**Last updated:** [May 20, 2020, 10:54pm UTC](https://www.singlestore.com/forum/t/row-level-security-feature/1969 "2020-05-20T22:54:06Z")

</div>

Hi, we are interested in MemSQL’s row level security features and have read the following document: But there are a few questions I like to get clarifications on: We have both a Java based multi-tenant application …

---

## [GRANT command for password change on Strict Mode](https://www.singlestore.com/forum/t/grant-command-for-password-change-on-strict-mode/1920)

<div class="topic-metadata">

**Author:** [@seungwoo.nam](https://www.singlestore.com/forum/u/seungwoo.nam)\
**Replies:** 0\
**Last updated:** [May 6, 2020, 2:43am UTC](https://www.singlestore.com/forum/t/grant-command-for-password-change-on-strict-mode/1920 "2020-05-06T02:43:13Z")

</div>

Hi. I have tried to test some privilege on strict mode. At strict mode permissions(SingleStoreDB Cloud · SingleStore Documentation), no.3 showed a different result with this link. The scenario follows. \[1. Login as ‘…

---

## [Best data type to store SHA2 data type](https://www.singlestore.com/forum/t/best-data-type-to-store-sha2-data-type/1864)

<div class="topic-metadata">

**Author:** [@rjsv](https://www.singlestore.com/forum/u/rjsv)\
**Replies:** 3\
**Last updated:** [April 29, 2020, 7:50pm UTC](https://www.singlestore.com/forum/t/best-data-type-to-store-sha2-data-type/1864 "2020-04-29T19:50:00Z")

</div>

By combining multiple columns using CONCAT & SHA2 ,we are creating a primary key column. Please guide us which is the best DATA TYPE to store SHA2 retrun values in a colum store table for better compression and perfoma…

[Next page](https://www.singlestore.com/forum/c/support/security/25.md?page=1)
