home *** CD-ROM | disk | FTP | other *** search
- Path: sparky!uunet!haven.umd.edu!darwin.sura.net!udel!gvls1!tredysvr!cellar!kml
- From: kml@cellar.org (John Galt)
- Newsgroups: comp.databases.oracle
- Subject: Re: Oracle7 userids
- Message-ID: <VT6gqB1w164w@cellar.org>
- Date: 2 Sep 92 12:57:06 GMT
- References: <1992Sep1.161828.337@hhcs.gov.au>
- Sender: bbs@cellar.org (The Cellar BBS)
- Organization: The Cellar BBS and public access system
- Lines: 27
-
- pihlab@hhcs.gov.au writes:
-
- >
- > Under Oracle6 when you revoke all access for a user there is no easy
- > way of actually removing them completely from the database ie they still
- > appear in the DBA_USERS table as a valid but inactive user.
- >
- > Has this changed under Oracle7 ?
- >
- > --
- >
- > Bruce... pihlab @ hhcs.gov.au
- > ^^
- >
- > PS. Someone please post a followup to this news group so I know that my
-
- Not only can you DROP USER in V7, you can also drop all their objects
- automatically via the DROP USER x CASCADE command. See Volume II,
- page 18-17 of the V7 Developers Version DBA Guide. This command gets
- rid of the user's old account completely.
-
- kml.
-
-
-
- As a matter of fact, no, I don't have a life.
- kml%cellar@tredysvr.tredydev.unisys.com - My other account is a Mercedes.
-