>revoke all ON DESKTOPUSER FROM "01CLARKKENT"
>does not raise an error??

What error do you expect?

I suppose the same kind of error that arises when I try to issue a select
statement where the syntax is clearly wrong, as in this statement.

It should be
revoke DESKTOPUSER from "01CLARKKENT"


"Regarding the deletion of users from the security database not triggering
the deletion of privileges granted to those users within each individual
database, it figures. The security db is just a database, after all. I
can't think of a practicable way that an automatic multi-database "chain
reaction" to deleting a user could be set off, unless the SYSDBA had
simultaneous exclusive access to all DBs on the server inside the same
transaction."

Well somehwere along the line, a multi database query takes place when you
log on - first the authentication takes place against the security database,
then the real database. So multi database actions aren't totally outside the
scope.

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/