Hello,
We created our Vertica database using the default settings. So now the database is owned by the Linux user dbadmin. Is it possible to change the database owner without reinstalling Vertica from scratch?
If anyone can help, I'd really appreciate it!
Change Database Owner
Moderator: NorbertKrupa
Change Database Owner
Last edited by Julie on Fri Apr 27, 2012 7:31 pm, edited 1 time in total.
Thanks,
Juliette
Juliette
Re: Change Database Owner
Hi!
[DELETED]
[DELETED]
Last edited by id10t on Fri May 08, 2015 9:23 pm, edited 1 time in total.
Re: Change Database Owner
OMG! Thank you! This is perfect! I tried this in our test system and it worked perfectly! Now to get signoff for PROD! Thank you so much! I'm a new DBA at my company and was thrown into this Vertica thing - which I certainly don't mind. Anyway, thanks for your help sKwa!
Thanks,
Juliette
Juliette
Re: Change Database Owner
You are welcome.
Of course it very simple example, GRANT statement has other useful options, see docs.Authorization and authentication very important in DB administration
Good luck.
Of course it very simple example, GRANT statement has other useful options, see docs.Authorization and authentication very important in DB administration
Good luck.
Re: Change Database Owner
Hi,
Me again, how did you get your prompt to look like this:
Me again, how did you get your prompt to look like this:
- [dbadmin :: ~ ]~>
Thanks,
Juliette
Juliette