[jira] [Commented] (TRAFODION-1573) Additional GET commands for privileges

["Roberta Marton (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/TRAFODION-1573?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15848877#comment-15848877 ] 

Roberta Marton commented on TRAFODION-1573:
-------------------------------------------

support for get privileges for user and get privileges for role have been added.

> Additional GET commands for privileges
> --------------------------------------
>
>                 Key: TRAFODION-1573
>                 URL: https://issues.apache.org/jira/browse/TRAFODION-1573
>             Project: Apache Trafodion
>          Issue Type: Improvement
>          Components: sql-security
>    Affects Versions: 1.3-incubating
>            Reporter: Roberta Marton
>            Assignee: Roberta Marton
>
> There are several GET PRIVILEGES commands that would be useful in describing security attributes for an object. Many of these commands exists for component privileges but need to be added for other objects.  
> This is a proposal to add the following commands:
> GET PRIVILEGES ON <object>
> GET PRIVILEGES ON <object> FOR <authid>
> <object> is:
>   libraries
>   procedures
>   functions (table_mapping functions)
>   views
>   tables
>   sequence generators
> <authID> is:
>      USER <username>
>      ROLE <role name>
>      auth name (gets USER and ROLE)



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)