Change Database Owner

Julie · Post by **Julie** » Thu Apr 19, 2012 9:33 pm

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!

id10t · Post by **id10t** » Sat Apr 21, 2012 10:01 pm

Hi!

[DELETED]

Julie · Post by **Julie** » Sun Apr 22, 2012 12:21 am

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!

id10t · Post by **id10t** » Sun Apr 22, 2012 12:27 am

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.

Julie · Post by **Julie** » Sun Apr 22, 2012 12:37 am

Hi,

Me again, how did you get your prompt to look like this:

[dbadmin :: ~ ]~>

Julie

Change Database Owner

Change Database Owner

Re: Change Database Owner

Re: Change Database Owner

Re: Change Database Owner

Re: Change Database Owner