Re: Is the owner of a table the schema?

On Fri, 8 Sep 2000 13:18:01 GMT, Brian Peasland <peasland_at_edcmail.cr.usgs.gov> wrote:

>> 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

Thanx!

Brian Received on Fri Sep 08 2000 - 12:11:26 CDT