CrackerSuperior commented on pull request #10998: URL: https://github.com/apache/shardingsphere/pull/10998#issuecomment-939606660
> > authority enhance，sample： > > ``` > > - !AUTHORITY > > users: > > - root@:root > > - user1@:user1 > > - [email protected]:user1 > > provider: > > type: SCHEMA_PRIVILEGES_PERMITTED > > props: > > user-schema-mappings: root@=test, [email protected]=db_dal_admin, user1@=test, user1@=db_dal_admin > > ``` > > > > > > > > > > > > > > > > > > > > > > > > when using root login from any host，you can use database test. when using user1 login from 127.0.0.1，you can use database db_dal_admin. when using user1 login from any other host，you can use database test and db_dal_admin. > > So, what if I want user1 to be able to use all the libraries? I know that "Native" or "ALL_PRIVILEGES_PERMITTED" can be configured separately to allow "user1" to view all libraries, but "SCHEMA_PRIVILEGES_PERMITTED" cannot be used. Using "SCHEMA_PRIVILEGES_PERMITTED" alone will overwrite the permissions of other users, causing users who do not use the "SCHEMA_PRIVILEGES_PERMITTED" configuration to see any libraries. Can "SCHEMA_PRIVILEGES_PERMITTED" be used together with "ALL_PRIVILEGES_PERMITTED"? -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
