[
https://issues.apache.org/jira/browse/TRAFODION-1573?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16063238#comment-16063238
]
Roberta Marton commented on TRAFODION-1573:
-------------------------------------------
Support for get privileges on table and get privileges on view 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.4.14#64029)