Oh - and I can't delete them manually out of the table because SYSDBA does
not have privilege to delet from this table>
Alan

-----Original Message-----
From: Alan McDonald [mailto:alan@...]
Sent: Friday, 4 April 2003 2:32 PM
To: ib-support@yahoogroups.com
Subject: [ib-support] RDB$USER_PRIVILEGES Question


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





To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/