Privileges with grant authority

From: Chris Boyle <cboyle_at_no.spam.hargray.com>
Date: Tue, 28 Nov 2000 13:15:40 -0500
Message-ID: <900spk$ddd$1@news3.infoave.net>

Okay folks I have seen this described 2 ways in various manuals so I decided to ask people that had experience. If USER A grants USER B a privilege with grant authority and USER B grants the privilege to USER C what happens to USER C if USER A revokes that privilege from USER B? Some of the books say that it will also be revoked from USER C and others state that USER C will retain the privilege. Which is correct? Has this changed with different versions of the DBMS (which would explain the inconsistency across books)?

8i on True 64/NT but I don't have the privileges to test this out here or I wouldn't bother you. Received on Tue Nov 28 2000 - 12:15:40 CST