rename user

[tomate]

hi gurus.
i need an information from you. Is it possible to rename a user (schema) that it has all the tables

Is there a solution.

Regards
Thomas

[shadow21]

Hi,
As far as I know, it is not possible...
However, you can perform an user export (fromuser=username), create a new user with same characteristics, drop cascade the user (which owns the tables), and then perform an import fromuser=olduser touser=newuser.

Hope it helps

Cheers

Fabien