Search found 5 matches
- Tue Oct 27, 2015 3:50 pm
- Forum: New to Vertica Database Administration
- Topic: Change owner of schema?
- Replies: 8
- Views: 46716
Re: Change owner of schema?
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 ...
- Wed Jan 14, 2015 5:26 pm
- Forum: Vertica Database Administration
- Topic: Replicating Users across clusters
- Replies: 8
- Views: 16039
Re: Replicating Users across clusters
Perfect! Thanks!norbertk wrote:Take a look at Doug's scripts which exports resource pools, roles, users, and permissions.
- Wed Jan 14, 2015 4:43 pm
- Forum: Vertica Database Administration
- Topic: Replicating Users across clusters
- Replies: 8
- Views: 16039
Re: Replicating Users across clusters
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...
- Wed Jan 14, 2015 4:21 pm
- Forum: Vertica Database Administration
- Topic: Replicating Users across clusters
- Replies: 8
- Views: 16039
Re: Replicating Users across clusters
>>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...
- Tue Jan 13, 2015 7:36 pm
- Forum: Vertica Database Administration
- Topic: Replicating Users across clusters
- Replies: 8
- Views: 16039
Replicating Users across clusters
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...