All of the above is how to change the default owner at schema creation. Is there anyway to change the owner of an already existing schema? Example: User Bob has created schema my_schema, owned by user Bob. Bob wins lotto and leaves company With Bob gone, we want to delete user Bob, but want to keep ...

norbertk wrote:Take a look at Doug's scripts which exports resource pools, roles, users, and permissions.

Perfect! Thanks!

Hi! But if you could maybe just expand on this, we could likely finish it off: No problem, pay me and you will get :) PS I have to say - for company like AOL its a boorishness to ask a free solution:) May be some nice developer, who do not appreciate it own time (time is money, right?) will provide...

>>If he’s using LDAP authentication, then the stored password issue isn’t an issue. Right, we are using LDAP, so password replications is not an issue. >>Or do you want a final solution? Do you want a script that generates restore-able dumps of users? Well, that would be nice. ;) But if you could ma...

We have two Vertica clusters, a primary and a secondary. We would like to have some sort of automation, or even semi-automated way to ensure that any users added to the primary also get added to the secondary. Even something that would run an SQL on v_catalog.users and then generate SQL to run on th...