[
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)
