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

Reply via email to