公开(公告)号：CA2384259A1

公开(公告)日：2003-10-29

申请号：CA2384259

申请日：2002-04-29

Applicant: IBM CANADA

Inventor： STUY MICHAEL A F ,  BIRD PAUL M

IPC: G06F21/30 ,  G06F16/21 ,  G06F12/14 ,  G06F12/02 ,  G06F17/30

Abstract: A method and system for permitting concurrent access to cached authorization information for an SQL database system. The authorization information is cached as consolidated bitmaps. A first, authorization, bitmap in the cache represents committed authorization information for a grantee and type of grantee. A second, cumulative delta, bitmap in each cache entry represents authorization information not yet committed. A cache entry state is recorded for each cach e entry. Access to the cumulative delta bitmap is provided where the database agent requesting acce ss is the agent carrying out a modification to the cached authorization information. Access to the authorization bitmap information is permitted, amongst other conditions, where a grant statement is uncommitted and the database agent requesting access is not seeking to modify the authorization