Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
phantom rows in grants system table
Hi, I am recently interacting with "grants" system table for a task involving grant management. It happens that I have a list of grants for a role/user X , lets say 200 instructions (for example GRANT SELECT for 200 objects), and if I look at "grants" system table I see strange things happen. For example, if I execute one by one these instructions, initially I see the new grants correctly and an increasing number of rows associated to grantee X in table "grants".. select * from grants where grantee = 'X'; but after a certain quantity of instructions, the grants already assigned start to disappear and are swapped with new ones... There are 2 strange things: - actually the grant assigned are still saved somewhere, in fact user/role X has privileges even if I don't see the corrisponding grants on the "grants" table any more - if I execute again the whole set of instructions there is no more this strange effect of phantom rows. can someone investigate on this topic? thanks in advance, Pietro