db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "haojie ma (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DERBY-6971) Grant permission based on Schema
Date Tue, 17 Oct 2017 20:43:00 GMT

    [ 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


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

GRANT ALL ON db1.* TO 'jeffrey'@'localhost';

See the doc below


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

> 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

View raw message