Page 1 of 2

Difference between dbadmin and psedosuperuser role

Posted: Fri May 02, 2014 2:14 pm
by keyur_nitc
Hi All,

Here is my first question.

What is the difference between dbadmin and pseudosuperuser role?
I see that both are same in terms of privileges.

Keyur

Re: Difference between dbadmin and psedosuperuser role

Posted: Fri May 02, 2014 3:13 pm
by id10t
Hi!

[DELETED]

Re: Difference between dbadmin and psedosuperuser role

Posted: Fri May 02, 2014 3:47 pm
by keyur_nitc
Thanks for the information.
But using PSEUDOSUPERUSER, one can grant oneself the dbadmin role and voila..!

Re: Difference between dbadmin and psedosuperuser role

Posted: Fri May 02, 2014 4:40 pm
by keyur_nitc
sKwa wrote:Not exactly. PSEUDOSUPERUSER can't create user, for example.
You're wrong here. PSEUDOSUPERUSER can create and alter user.!!!

Re: Difference between dbadmin and psedosuperuser role

Posted: Fri May 02, 2014 7:08 pm
by id10t
Hi!

[DELETED]

Re: Difference between dbadmin and psedosuperuser role

Posted: Mon May 05, 2014 6:53 am
by keyur_nitc
keyur_nitc wrote:alter ok, create should not: https://my.vertica.com/docs/7.0.x/HTML/ ... ERRole.htm
Wrong again :). one can create users too. We should try and run the commands rather just interpreting the docs. ;)

Re: Difference between dbadmin and psedosuperuser role

Posted: Mon May 12, 2014 6:25 am
by keyur_nitc
No answer to my question?