[ https://issues.apache.org/jira/browse/DERBY-6971?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16208297#comment-16208297 ]
haojie ma commented on DERBY-6971: ---------------------------------- Rich, sure. Here is several example 1. MS Sql server, it supports to grant permission based on schema. See the link below https://docs.microsoft.com/en-us/sql/t-sql/statements/grant-schema-permissions-transact-sql 2. Mysql also supports it. Although it is grant on table granularity, it supports wild card, such as *, so a user can grant permission to a user for all the tables using on statement. Here is the an example {code:java} GRANT ALL ON db1.* TO 'jeffrey'@'localhost'; {code} See the doc below https://dev.mysql.com/doc/refman/5.7/en/grant.html Grant permission based on schema is a great feature, it can make the grant permission easier for end users. Grant once on schema, and the end users don't need to grant newly created tables under the schema. > Grant permission based on Schema > -------------------------------- > > Key: DERBY-6971 > URL: https://issues.apache.org/jira/browse/DERBY-6971 > Project: Derby > Issue Type: Improvement > Components: SQL > Reporter: haojie ma > > Right now, Derby doesn't support grant permission based on schema, it only > support on the table level. It is easier for the users if derby can have this > feature. -- This message was sent by Atlassian JIRA (v6.4.14#64029)