Re: oracle question: how to delete an oracle user?
From: bs <shatzman_at_netcom.com>
Date: Wed, 4 May 1994 18:31:41 GMT
Message-ID: <shatzmanCpAJGt.Brv_at_netcom.com>
Date: Wed, 4 May 1994 18:31:41 GMT
Message-ID: <shatzmanCpAJGt.Brv_at_netcom.com>
Stuart Cracraft (cracraft_at_rice-chex.ai.mit.edu) wrote:
: How do I delete an Oracle user created with:
: grant connect to WHOEVER identified by PASSWORD;
: i.e., I want to delete the user "WHOEVER".
In v6, you can't. You can REVOKE CONNECT etc from a user, but the id will remain in the data dictionary. The only legit way to remove any reference to a user is to rebuild the database.
In ORACLE7, a user can be deleted.
barry Received on Wed May 04 1994 - 20:31:41 CEST