[ https://issues.apache.org/jira/browse/TRAFODION-1573?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16482655#comment-16482655 ]
ASF GitHub Bot commented on TRAFODION-1573: ------------------------------------------- Github user asfgit closed the pull request at: https://github.com/apache/trafodion/pull/1568 > 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 > Priority: Major > > 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 (v7.6.3#76005)