Re: drop user

AFAIK , no --
But the schema does not have to represent a user that can connect to the database.... I believe you can create a user ( say OWNER ), build the objects you want and after granting rights, creating synonyms, etc , disable that user's account ..( as sysdba you can re enable it if you need to make changes)

xx32 <i.dont.want.sp_at_m.com> wrote:

>is it possible to have a schema without a user?

-----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------

   http://www.newsfeed.com The #1 Newsgroup Service in the World! -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =----- Received on Fri Sep 27 2002 - 13:08:35 CDT