# Security

**URL:** https://www.singlestore.com/forum/c/support/security/25.md?page=1

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

**Page:** 2

---

## [What is the meaning of sync and local in 'is local' of show users command](https://www.singlestore.com/forum/t/what-is-the-meaning-of-sync-and-local-in-is-local-of-show-users-command/1844)

<div class="topic-metadata">

**Author:** [@rjsv](https://www.singlestore.com/forum/u/rjsv)\
**Replies:** 1\
**Last updated:** [April 23, 2020, 6:51pm UTC](https://www.singlestore.com/forum/t/what-is-the-meaning-of-sync-and-local-in-is-local-of-show-users-command/1844 "2020-04-23T18:51:03Z")

</div>

I have created four different users with specific privileges. But when I run the “show users” command I am seeing all users as below. Please let me know below things. What is the meaning of connections ? What is the …

---

## [Created multiple users but I am seeing very few users only when I run show grants](https://www.singlestore.com/forum/t/created-multiple-users-but-i-am-seeing-very-few-users-only-when-i-run-show-grants/1843)

<div class="topic-metadata">

**Author:** [@rjsv](https://www.singlestore.com/forum/u/rjsv)\
**Replies:** 1\
**Last updated:** [April 23, 2020, 6:43pm UTC](https://www.singlestore.com/forum/t/created-multiple-users-but-i-am-seeing-very-few-users-only-when-i-run-show-grants/1843 "2020-04-23T18:43:24Z")

</div>

I have created four different users with specific privileges. But when I run the below command I am seeing only root user. I am not seeing any other user other than root. show grants;

---

## [Is it advisable to use SHA1](https://www.singlestore.com/forum/t/is-it-advisable-to-use-sha1/1865)

<div class="topic-metadata">

**Author:** [@rjsv](https://www.singlestore.com/forum/u/rjsv)\
**Replies:** 2\
**Last updated:** [April 23, 2020, 6:35pm UTC](https://www.singlestore.com/forum/t/is-it-advisable-to-use-sha1/1865 "2020-04-23T18:35:27Z")

</div>

I have gone through the below link. Looks like SHA1 has been deprecated and kept for backwards compatibility. We are using 7.0. Please let us know how long will you support the same in case if we use this in our busi…

---

## [Unable to connect after changing the Root password](https://www.singlestore.com/forum/t/unable-to-connect-after-changing-the-root-password/1846)

<div class="topic-metadata">

**Author:** [@rjsv](https://www.singlestore.com/forum/u/rjsv)\
**Replies:** 2\
**Last updated:** [April 22, 2020, 2:35pm UTC](https://www.singlestore.com/forum/t/unable-to-connect-after-changing-the-root-password/1846 "2020-04-22T14:35:00Z")

</div>

I have changed the root password of the memsql cluster as below. But I am unable to connect to the memsql cluster using the latest password. When I try to connect with latest password , I am facing an error as "ERROR …

---

## [Which privilege required create procedure/function](https://www.singlestore.com/forum/t/which-privilege-required-create-procedure-function/1837)

<div class="topic-metadata">

**Author:** [@rjsv](https://www.singlestore.com/forum/u/rjsv)\
**Replies:** 2\
**Last updated:** [April 20, 2020, 2:44am UTC](https://www.singlestore.com/forum/t/which-privilege-required-create-procedure-function/1837 "2020-04-20T02:44:01Z")

</div>

Please let me know which privilege is required to create stored procedure/function.

---

## [How to create a database administrator user (DBA user)?](https://www.singlestore.com/forum/t/how-to-create-a-database-administrator-user-dba-user/1791)

<div class="topic-metadata">

**Author:** [@rjsv](https://www.singlestore.com/forum/u/rjsv)\
**Replies:** 1\
**Last updated:** [April 9, 2020, 5:38pm UTC](https://www.singlestore.com/forum/t/how-to-create-a-database-administrator-user-dba-user/1791 "2020-04-09T17:38:09Z")

</div>

As I know root is the default administrator user who has full access on Memsql Cluster. Please let me know how to add a database administrator user (DBA user) and which grants need to provide to him. It would be helpful…

---

## [What is "MemSQL Advanced Security Option license"?](https://www.singlestore.com/forum/t/what-is-memsql-advanced-security-option-license/1799)

<div class="topic-metadata">

**Author:** [@kyoungho.kum](https://www.singlestore.com/forum/u/kyoungho.kum)\
**Replies:** 1\
**Last updated:** [April 9, 2020, 1:21pm UTC](https://www.singlestore.com/forum/t/what-is-memsql-advanced-security-option-license/1799 "2020-04-09T13:21:39Z")

</div>

Dear team, The following warnings are in the docs. Warning As of the time of this publication, audit logging features are made available and licensed only as part of the MemSQL Advanced Security Option. Before using …

---

## [How to create a new user in memsql](https://www.singlestore.com/forum/t/how-to-create-a-new-user-in-memsql/1732)

<div class="topic-metadata">

**Author:** [@sandeep.patra](https://www.singlestore.com/forum/u/sandeep.patra)\
**Replies:** 2\
**Last updated:** [March 25, 2020, 7:38pm UTC](https://www.singlestore.com/forum/t/how-to-create-a-new-user-in-memsql/1732 "2020-03-25T19:38:40Z")

</div>

I created a user using the below sql stmts but still the user cant access remotely from sqldbx tool . CREATE USER ‘california’@’%’ IDENTIFIED BY ‘Tesla123#’; grant group ‘am\_data\_read\_only\_group’ to ‘california’@’%’; …

---

## [Error: unable to get issuer certificate from Nodejs](https://www.singlestore.com/forum/t/error-unable-to-get-issuer-certificate-from-nodejs/1377)

<div class="topic-metadata">

**Author:** [@geet](https://www.singlestore.com/forum/u/geet)\
**Replies:** 2\
**Last updated:** [November 15, 2019, 5:35pm UTC](https://www.singlestore.com/forum/t/error-unable-to-get-issuer-certificate-from-nodejs/1377 "2019-11-15T17:35:59Z")

</div>

Hello, We are using npm mysql 2.17.1 to connect to memsql 6.8.7. Sample nodejs code: let poolSettings = { host: config.host, port: config.port, user: config.user, password: con…

---

## [Has anyone used Amazon Cognito to authenticate users to memsql db?](https://www.singlestore.com/forum/t/has-anyone-used-amazon-cognito-to-authenticate-users-to-memsql-db/1099)

<div class="topic-metadata">

**Author:** [@kbulls2012](https://www.singlestore.com/forum/u/kbulls2012)\
**Replies:** 1\
**Last updated:** [August 8, 2019, 7:37pm UTC](https://www.singlestore.com/forum/t/has-anyone-used-amazon-cognito-to-authenticate-users-to-memsql-db/1099 "2019-08-08T19:37:54Z")

</div>

I want to use Amazon Cognito ( Authentication Service - Customer IAM (CIAM) - Amazon Cognito - AWS ) for secure user authentication to my memsql database. Any tutorials or information would be appreciated. Thank you.

---

## [Definer Security Model Best Practices](https://www.singlestore.com/forum/t/definer-security-model-best-practices/1030)

<div class="topic-metadata">

**Author:** [@bvincent](https://www.singlestore.com/forum/u/bvincent)\
**Replies:** 2\
**Last updated:** [July 30, 2019, 9:14pm UTC](https://www.singlestore.com/forum/t/definer-security-model-best-practices/1030 "2019-07-30T21:14:40Z")

</div>

MemSQL follows the definer security model for objects such as views and procedures. In other words, a user who has access to execute a view (for example) will have access to the underlying objects so long as the view’s c…

---

## [Unable to start the master node after updating the ssl\_cert and ssl\_key in memsql.cnf](https://www.singlestore.com/forum/t/unable-to-start-the-master-node-after-updating-the-ssl-cert-and-ssl-key-in-memsql-cnf/695)

<div class="topic-metadata">

**Author:** [@molalwan](https://www.singlestore.com/forum/u/molalwan)\
**Replies:** 6\
**Last updated:** [May 24, 2019, 11:50am UTC](https://www.singlestore.com/forum/t/unable-to-start-the-master-node-after-updating-the-ssl-cert-and-ssl-key-in-memsql-cnf/695 "2019-05-24T11:50:36Z")

</div>

Hi I’m following the given memsql documentation SingleStoreDB Cloud · SingleStore Documentation to enable ssl connection between my service and memsql node but whenever I update the master’s memsq.cnf file with ssl\_cert…

---

## [Does memsql support tls based connections?](https://www.singlestore.com/forum/t/does-memsql-support-tls-based-connections/650)

<div class="topic-metadata">

**Author:** [@molalwan](https://www.singlestore.com/forum/u/molalwan)\
**Replies:** 2\
**Last updated:** [May 8, 2019, 7:18am UTC](https://www.singlestore.com/forum/t/does-memsql-support-tls-based-connections/650 "2019-05-08T07:18:25Z")

</div>

I’m trying to secure memsql connection through ssl. Does memsql support one-way authentication or is it necessary to have a 2-way authentication?

---

## [Securing resource pools](https://www.singlestore.com/forum/t/securing-resource-pools/541)

<div class="topic-metadata">

**Author:** [@bvincent](https://www.singlestore.com/forum/u/bvincent)\
**Replies:** 1\
**Last updated:** [April 11, 2019, 8:45pm UTC](https://www.singlestore.com/forum/t/securing-resource-pools/541 "2019-04-11T20:45:21Z")

</div>

Is there a way to secure resource pools so that users can’t just set their resource pool to the least restrictive one?

---

## [Does MemSQL support user passwords in a configuration file?](https://www.singlestore.com/forum/t/does-memsql-support-user-passwords-in-a-configuration-file/523)

<div class="topic-metadata">

**Author:** [@daemon\_of\_chaos](https://www.singlestore.com/forum/u/daemon_of_chaos)\
**Replies:** 7\
**Last updated:** [April 4, 2019, 12:16am UTC](https://www.singlestore.com/forum/t/does-memsql-support-user-passwords-in-a-configuration-file/523 "2019-04-04T00:16:26Z")

</div>

MySQL supports storing user passwords in a ~/.my.cnf file (https://dev.mysql.com/doc/refman/8.0/en/password-security-user.html). Does MemSQL support similar functionality and if so can you point me to the documentation.…

---

## [What are the correct permissions to allow a user to query tables in \`information\_schema\`](https://www.singlestore.com/forum/t/what-are-the-correct-permissions-to-allow-a-user-to-query-tables-in-information-schema/399)

<div class="topic-metadata">

**Author:** [@scott](https://www.singlestore.com/forum/u/scott)\
**Replies:** 2\
**Last updated:** [March 10, 2019, 2:19am UTC](https://www.singlestore.com/forum/t/what-are-the-correct-permissions-to-allow-a-user-to-query-tables-in-information-schema/399 "2019-03-10T02:19:36Z")

</div>

Looking to grant our Tableau a user limited permissions. So far, this has worked: GRANT SELECT, CREATE TEMPORARY TABLES, SHOW METADATA ON warehouse.\* TO tableau\_server@'%'; In Tableau, I can see the information\_schema …

[Previous page](https://www.singlestore.com/forum/c/support/security/25.md)
