[MCOL-601] New CREATE USER functions Created: 2017-02-28  Updated: 2024-01-04  Resolved: 2017-06-23

Status: Closed
Project: MariaDB ColumnStore
Component/s: MDB Plugin
Affects Version/s: 1.1.0
Fix Version/s: N/A

Type: New Feature Priority: Major
Reporter: David Hall (Inactive) Assignee: Daniel Lee (Inactive)
Resolution: Fixed Votes: 0
Labels: 10.2

Sprint: 2017-12, 2017-13

 Description   

MariaDB Server 10.2 added the following functions which need to be implemented in Columnstore:

The SHOW CREATE USER statement was introduced.
New CREATE USER options for limiting resource usage and tls/ssl.
New ALTER USER statement



 Comments   
Comment by David Thompson (Inactive) [ 2017-06-12 ]

Can you review / verify these and add new test cases or bugs as appropriate.

Comment by Daniel Lee (Inactive) [ 2017-06-23 ]

Build tested: Github source 1.1.0

[root@localhost mariadb-columnstore-server]# git show
commit 60f2f261f81d994307762d6d93380873513a0be8
Author: david hill <david.hill@mariadb.com>
Date: Tue Jun 20 16:05:32 2017 -0500

[root@localhost mariadb-columnstore-engine]# git show
commit f126f3b019cea81e3c363db47cb23aeaac1e2ef9
Author: david hill <david.hill@mariadb.com>
Date: Mon Jun 19 15:28:24 2017 -0500

Tested again. The “CREATE USER”, “ALTER USER”, “SHOW CREATE USER” commands worked fine with ColumnStore. I ran into issue only when I tried SSL connections.

As a requirement for a new user, the new user must have privileges to the infinidb_vtable database.

I believe these three commands affect only the front end. Developer should add their opinions whether or not any modification is needed in the ColumnStore engine to support these three commands.

I did run into an issue when I tried to setup SSL connection on the server. I have issue connecting from a client. Most likely, I did not have all the pieces put together for secured connection to work. This should not affect the scope of purpose of this ticket.

Comment by Daniel Lee (Inactive) [ 2017-06-23 ]

Completed investigation for this ticket.

Generated at Thu Feb 08 02:22:18 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.