Hi,
Which version of Oracle you are using.If you are using Oracle 8i and above you can write database or schema level triggers to restrict users to connect the Z,Y,Q users or else dont give the passwords of Z,Y,Q to user A,B,C,D.

Regards,
Rohit Nirkhe,Oracle DBA,OCP 8i
[email protected]