Thread

Re: Grant / Revoke functionality

Shridhar Daithankar <shridhar_daithankar@persistent.co.in> — 2004-02-18T09:37:14Z

On Wednesday 18 February 2004 14:41, Alexander Priem wrote:
> Thanks for your reply.
>
> I already have all the tables/views/sequences set up and filled. Can I
> create a new schema and 'assign' the existing tables/views/sequences to
> this new schema? Will this affect current queries I have created?

You mean alter table set schema to foo? I doubt you can do that..

What you can do is dump/reload a single schema. After dumping the schema, edit 
the dump to schema creation/set search path by hand and it will insert the 
objects in the new schema..

HTH

 Shridhar