Subject | RDB$USER_PRIVILEGES Question |
---|---|
Author | Alan McDonald |
Post date | 2003-04-04T04:32:04Z |
I've just noticed that after adding users to my server, granting them
privileges, then deleting them, I'm left with entries in my
RDB$USER_PRIVILEGES table. I only spotted this becuase IBLogmanager lists
these people as USERS in the database, even though they are not on the
server anymore and have no priviliges.
Another Q - they are listed as having the M Privilege.
I've tried re-creating these users, then revoking their rights to the ROLE
they are privilege to but they remain in the table.
Anyone know how they are deleted? How do I stop these deleted users from
remaining in this table?
thanks
Alan
privileges, then deleting them, I'm left with entries in my
RDB$USER_PRIVILEGES table. I only spotted this becuase IBLogmanager lists
these people as USERS in the database, even though they are not on the
server anymore and have no priviliges.
Another Q - they are listed as having the M Privilege.
I've tried re-creating these users, then revoking their rights to the ROLE
they are privilege to but they remain in the table.
Anyone know how they are deleted? How do I stop these deleted users from
remaining in this table?
thanks
Alan