Re: Is the owner of a table the schema?

> So, if you create a user, have the user create tables, and then drop
> the user, what hapens to the tables?

If the user has created objects (tables, indexes, etc.) and you issue the following:

  DROP USER username;

Then you'll get an error. You can not drop a user and leave the objects intact. If you wish to drop the user and all of the user's objects in one command, you can issue:  

  DROP USER username CASCADE;

HTH,
Brian

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================