OK Sorry - slightly wrong syntax on my revoke statement
funny that the syntax error does not create an exception.. why is this?
e.g.
revoke all ON DESKTOPUSER FROM "01CLARKKENT"
does not raise an error??
Alan

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


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/





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/