[
https://issues.apache.org/jira/browse/TRAFODION-2600?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Roberta Marton resolved TRAFODION-2600.
---------------------------------------
Resolution: Fixed
> Unable to create view (lack of SELECT privilege) but user has SELECT privilege
> ------------------------------------------------------------------------------
>
> Key: TRAFODION-2600
> URL: https://issues.apache.org/jira/browse/TRAFODION-2600
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-security
> Reporter: Roberta Marton
> Assignee: Roberta Marton
> Priority: Major
>
> User unable to create a view because of missing SELECT privilege but user has
> been granted privilege through a role.
> admin
> - creates role1;
> - creates table1 - grant select on table1 to role1
> user1
> - tries to create a view - unable because of no SELECT priv
> admin
> - grants role1 to user1
> User1
> - still unable to create view
> - if user1 selects from table1 - it succeeds and a subsequent create view
> works.
> When a user connects, its list of active roles are stored in cache.
> If the user is subsequently granted new roles, the in memory list should be
> updated. For DML requests, the in memory list is updated. For DDL requests,
> the in memory list is not updated.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
