Skip to content
This repository has been archived by the owner on Dec 1, 2022. It is now read-only.

i want to export privileges data only #1231

Closed
riverzzz opened this issue Jul 9, 2021 · 2 comments
Closed

i want to export privileges data only #1231

riverzzz opened this issue Jul 9, 2021 · 2 comments
Labels
feature req Type: feature request

Comments

@riverzzz
Copy link

riverzzz commented Jul 9, 2021

Summary

i want to export privileges data only.

Motivation

i create a new cluster and i change space partitions,so i do not need data info.but i have grant privilege to too many users in old cluster,so i want to export privileges data or privileges sql.

@Shylock-Hg
Copy link
Contributor

Shylock-Hg commented Jul 13, 2021

I think you could do it now already.

  1. show spaces to get all spaces
  2. show create space <> to get query to create space
  3. show users to get all users, then assemble the create user query
  4. show roles in <> to get all permission in space, then you could assemble the grant query.

@wey-gu
Copy link

wey-gu commented Jul 16, 2021

Will close it as it's been inactive for days. Feel free to reopen it.

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
feature req Type: feature request
Projects
None yet
Development

No branches or pull requests

3 participants