hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Thejas M Nair (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-5940) SQL std auth - support new 'show grant..' statements
Date Wed, 04 Dec 2013 03:37:35 GMT

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

Thejas M Nair updated HIVE-5940:
--------------------------------

    Description: 
SHOW GRANTS statement -
It will give a list of objects, privileges, and who granted the grantee rights on that object
- When used by a user who does not participate in the SUPERUSER role, it can be
used in three ways
-- SHOW GRANTS; This will show all grants effective for the current user or
roles, whichever is currently determining the user’s privileges.
-- SHOW GRANTS FOR role; This will show grants effective for a given
role. The user must participate in that role, otherwise permission will be
denied.
-- SHOW GRANTS FOR user; where user is the username of the current
user. This will show grants effective for the user. Attempts to list grants
effective for other users will be denied.
- When used by a user who does participate in the SUPERUSER role, it can be
used in three ways:
-- SHOW GRANTS; As in the previous section.
-- SHOW GRANTS FOR role; This will show grants effective for a given
role. Any role, regardless of whether the current user participates in it,
can be shown.
-- SHOW GRANTS FOR user; where user is a valid username. This will
show grants effective for that user. Any user, regardless of whether it is
the current user, can be shown

Task includes authorization of the statement.


  was:
SHOW GRANTS statement -
It will give a list of objects, privileges, and who granted the grantee rights on that object
- When used by a user who does not participate in the SUPERUSER role, it can be
used in three ways
-- SHOW GRANTS; This will show all grants effective for the current user or
roles, whichever is currently determining the user’s privileges.
-- SHOW GRANTS FOR role; This will show grants effective for a given
role. The user must participate in that role, otherwise permission will be
denied.
-- SHOW GRANTS FOR user; where user is the username of the current
user. This will show grants effective for the user. Attempts to list grants
effective for other users will be denied.
- When used by a user who does participate in the SUPERUSER role, it can be
used in three ways:
-- SHOW GRANTS; As in the previous section.
-- SHOW GRANTS FOR role; This will show grants effective for a given
role. Any role, regardless of whether the current user participates in it,
can be shown.
-- SHOW GRANTS FOR user; where user is a valid username. This will
show grants effective for that user. Any user, regardless of whether it is
the current user, can be shown



> SQL std auth - support new 'show grant..' statements
> ----------------------------------------------------
>
>                 Key: HIVE-5940
>                 URL: https://issues.apache.org/jira/browse/HIVE-5940
>             Project: Hive
>          Issue Type: Sub-task
>          Components: Authorization
>            Reporter: Thejas M Nair
>   Original Estimate: 24h
>  Remaining Estimate: 24h
>
> SHOW GRANTS statement -
> It will give a list of objects, privileges, and who granted the grantee rights on that
object
> - When used by a user who does not participate in the SUPERUSER role, it can be
> used in three ways
> -- SHOW GRANTS; This will show all grants effective for the current user or
> roles, whichever is currently determining the user’s privileges.
> -- SHOW GRANTS FOR role; This will show grants effective for a given
> role. The user must participate in that role, otherwise permission will be
> denied.
> -- SHOW GRANTS FOR user; where user is the username of the current
> user. This will show grants effective for the user. Attempts to list grants
> effective for other users will be denied.
> - When used by a user who does participate in the SUPERUSER role, it can be
> used in three ways:
> -- SHOW GRANTS; As in the previous section.
> -- SHOW GRANTS FOR role; This will show grants effective for a given
> role. Any role, regardless of whether the current user participates in it,
> can be shown.
> -- SHOW GRANTS FOR user; where user is a valid username. This will
> show grants effective for that user. Any user, regardless of whether it is
> the current user, can be shown
> Task includes authorization of the statement.



--
This message was sent by Atlassian JIRA
(v6.1#6144)

Mime
View raw message