sentry-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Brock Noland (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (SENTRY-150) Support various SHOW commands
Date Tue, 18 Mar 2014 02:53:42 GMT

     [ https://issues.apache.org/jira/browse/SENTRY-150?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Brock Noland updated SENTRY-150:
--------------------------------

    Description: 
Specifically, I think we have to implement

* SHOW ROLES
* SHOW GRANT ROLE xxx ON [SERVER, DATABASE, TABLE, URI] xxx
* SHOW ROLE GRANT GROUP xxxx.

The following is the output of testing hive with these commands

{noformat}
> CREATE ROLE r1;
> GRANT ROLE r1 to GROUP staff;
> GRANT ALL ON DATABASE default TO ROLE r1;
> SHOW GRANT ROLE r1 ON DATABASE default; 
default                    r1     ROLE     All     false     1395109913000     noland
> CREATE TABLE t1 (c1 string)

> GRANT ALL ON TABLE t1 TO ROLE r1;
> SHOW GRANT ROLE r1 ON TABLE t1;       
default     t1               r1     ROLE     All     false     1395110129000     noland

      appendNonNull(builder, resource.getDbName(), true);
      appendNonNull(builder, resource.getObjectName());
      appendNonNull(builder, resource.getPartValues());
      appendNonNull(builder, resource.getColumnName());
      appendNonNull(builder, privilege.getPrincipalName());
      appendNonNull(builder, privilege.getPrincipalType());
      appendNonNull(builder, grantInfo.getPrivilege());
      appendNonNull(builder, grantInfo.isGrantOption());
      appendNonNull(builder, testMode ? -1 : grantInfo.getCreateTime() * 1000L);
      appendNonNull(builder, grantInfo.getGrantor());

> SHOW ROLE GRANT GROUP staff;
r1     1395109787000     staff     GROUP     false     1395109830000     noland

      appendNonNull(builder, role.getRoleName(), true);
      appendNonNull(builder, testMode ? -1 : role.getCreateTime() * 1000L);
      appendNonNull(builder, role.getPrincipalName());
      appendNonNull(builder, role.getPrincipalType());
      appendNonNull(builder, role.isGrantOption());
      appendNonNull(builder, testMode ? -1 : role.getGrantTime() * 1000L);
      appendNonNull(builder, role.getGrantor());

> SHOW ROLES;
r1
        for (String roleName : roleNames) {
          outStream.writeBytes(roleName);
          outStream.write(terminator);

{noformat}

> Support various SHOW commands
> -----------------------------
>
>                 Key: SENTRY-150
>                 URL: https://issues.apache.org/jira/browse/SENTRY-150
>             Project: Sentry
>          Issue Type: Sub-task
>            Reporter: Brock Noland
>
> Specifically, I think we have to implement
> * SHOW ROLES
> * SHOW GRANT ROLE xxx ON [SERVER, DATABASE, TABLE, URI] xxx
> * SHOW ROLE GRANT GROUP xxxx.
> The following is the output of testing hive with these commands
> {noformat}
> > CREATE ROLE r1;
> > GRANT ROLE r1 to GROUP staff;
> > GRANT ALL ON DATABASE default TO ROLE r1;
> > SHOW GRANT ROLE r1 ON DATABASE default; 
> default                    r1     ROLE     All     false     1395109913000     noland
> > CREATE TABLE t1 (c1 string)
> > GRANT ALL ON TABLE t1 TO ROLE r1;
> > SHOW GRANT ROLE r1 ON TABLE t1;       
> default     t1               r1     ROLE     All     false     1395110129000     noland
>       appendNonNull(builder, resource.getDbName(), true);
>       appendNonNull(builder, resource.getObjectName());
>       appendNonNull(builder, resource.getPartValues());
>       appendNonNull(builder, resource.getColumnName());
>       appendNonNull(builder, privilege.getPrincipalName());
>       appendNonNull(builder, privilege.getPrincipalType());
>       appendNonNull(builder, grantInfo.getPrivilege());
>       appendNonNull(builder, grantInfo.isGrantOption());
>       appendNonNull(builder, testMode ? -1 : grantInfo.getCreateTime() * 1000L);
>       appendNonNull(builder, grantInfo.getGrantor());
> > SHOW ROLE GRANT GROUP staff;
> r1     1395109787000     staff     GROUP     false     1395109830000     noland
>       appendNonNull(builder, role.getRoleName(), true);
>       appendNonNull(builder, testMode ? -1 : role.getCreateTime() * 1000L);
>       appendNonNull(builder, role.getPrincipalName());
>       appendNonNull(builder, role.getPrincipalType());
>       appendNonNull(builder, role.isGrantOption());
>       appendNonNull(builder, testMode ? -1 : role.getGrantTime() * 1000L);
>       appendNonNull(builder, role.getGrantor());
> > SHOW ROLES;
> r1
>         for (String roleName : roleNames) {
>           outStream.writeBytes(roleName);
>           outStream.write(terminator);
> {noformat}



--
This message was sent by Atlassian JIRA
(v6.2#6252)

Mime
View raw message