New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Complete implementation of schema_locked #1133

Open
renecannao opened this Issue Aug 14, 2017 · 0 comments

Comments

Projects
None yet
1 participant
@renecannao
Contributor

renecannao commented Aug 14, 2017

The implementation of mysql_users.schema_locked is not completed.

Once completed:

  • clients can connect only to their default_schema
  • clients won't be able to issue any USE command

Yet, proxysql won't disable cross schema SELECT/DML

@renecannao renecannao added this to the v1.4.2 milestone Aug 14, 2017

@renecannao renecannao self-assigned this Aug 14, 2017

renecannao added a commit that referenced this issue Aug 15, 2017

Several ClickHouse enhancement
* graceful handle of missing backend (before was just crashing)
* code cleanup
* adding an embedded SQLite3 connections inside ClickHouse Server to execute internally dummy queries
* filter of several SET commands
* support for SHOW [SESSION ](VARIABLES|STATUS) LIKE
* support for SHOW [GLOBAL|ALL] VARIABLES
* support for SHOW GLOBAL STATUS
* support for SHOW COLLATION #1136
* support for SHOW CHARSET #1136
* support for SHOW ENGINES #1139
* support for SELECT current_user() #1135
* support for SELECT CONNECTION_ID() #1133
* support for SHOW FULL TABLES FROM `default`
* working semi-support for SHOW COLUMNS FROM

renecannao added a commit that referenced this issue Sep 9, 2017

Several ClickHouse enhancement
* graceful handle of missing backend (before was just crashing)
* code cleanup
* adding an embedded SQLite3 connections inside ClickHouse Server to execute internally dummy queries
* filter of several SET commands
* support for SHOW [SESSION ](VARIABLES|STATUS) LIKE
* support for SHOW [GLOBAL|ALL] VARIABLES
* support for SHOW GLOBAL STATUS
* support for SHOW COLLATION #1136
* support for SHOW CHARSET #1136
* support for SHOW ENGINES #1139
* support for SELECT current_user() #1135
* support for SELECT CONNECTION_ID() #1133
* support for SHOW FULL TABLES FROM `default`
* working semi-support for SHOW COLUMNS FROM
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment