Re: deleting users
From: Kenny Gump <kgump_at_mylanlabs.com>
Date: 1999/03/25
Message-ID: <36fa7420.0_at_news.mountain.net>#1/1
J. G. Dutcher wrote in message ...
>I'm feeling rather stupid. I have an application up and running that I
>helped develop. Now due to changes in staff, I need to delete some of the
>users. I've checked the oracle manuals and can not find any thing about
>deleting users. Maybe I'm too close to the forest to see the trees but
>this shouldn't be a difficult task.
>
>Any help would be appreciated.
>
>TIA
>
>TIA
>
Received on Thu Mar 25 1999 - 00:00:00 CET
Date: 1999/03/25
Message-ID: <36fa7420.0_at_news.mountain.net>#1/1
The syntax is:
drop user username;
In Oracle you only 'delete' rows from a table. If you want to get rid of some object you 'drop' it.
Kenny Gump
OCP 7.3 DBA
J. G. Dutcher wrote in message ...
>I'm feeling rather stupid. I have an application up and running that I
>helped develop. Now due to changes in staff, I need to delete some of the
>users. I've checked the oracle manuals and can not find any thing about
>deleting users. Maybe I'm too close to the forest to see the trees but
>this shouldn't be a difficult task.
>
>Any help would be appreciated.
>
>TIA
>
>TIA
>
Received on Thu Mar 25 1999 - 00:00:00 CET