Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Fixed
-
None
-
None
-
None
Description
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.
Attachments
Issue Links
- links to