Difference between dbadmin and psedosuperuser role

Moderator: NorbertKrupa

keyur_nitc
Newbie
Newbie
Posts: 5
Joined: Fri May 02, 2014 8:23 am

Difference between dbadmin and psedosuperuser role

Post by keyur_nitc » Fri May 02, 2014 2:14 pm

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

id10t
GURU
GURU
Posts: 732
Joined: Mon Apr 16, 2012 2:44 pm

Re: Difference between dbadmin and psedosuperuser role

Post by id10t » Fri May 02, 2014 3:13 pm

Hi!

[DELETED]
Last edited by id10t on Wed May 06, 2015 5:23 pm, edited 1 time in total.

keyur_nitc
Newbie
Newbie
Posts: 5
Joined: Fri May 02, 2014 8:23 am

Re: Difference between dbadmin and psedosuperuser role

Post by keyur_nitc » Fri May 02, 2014 3:47 pm

Thanks for the information.
But using PSEUDOSUPERUSER, one can grant oneself the dbadmin role and voila..!

keyur_nitc
Newbie
Newbie
Posts: 5
Joined: Fri May 02, 2014 8:23 am

Re: Difference between dbadmin and psedosuperuser role

Post by keyur_nitc » Fri May 02, 2014 4:40 pm

sKwa wrote:Not exactly. PSEUDOSUPERUSER can't create user, for example.
You're wrong here. PSEUDOSUPERUSER can create and alter user.!!!

id10t
GURU
GURU
Posts: 732
Joined: Mon Apr 16, 2012 2:44 pm

Re: Difference between dbadmin and psedosuperuser role

Post by id10t » Fri May 02, 2014 7:08 pm

Hi!

[DELETED]
Last edited by id10t on Wed May 06, 2015 5:23 pm, edited 1 time in total.

keyur_nitc
Newbie
Newbie
Posts: 5
Joined: Fri May 02, 2014 8:23 am

Re: Difference between dbadmin and psedosuperuser role

Post by keyur_nitc » Mon May 05, 2014 6:53 am

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. ;)

keyur_nitc
Newbie
Newbie
Posts: 5
Joined: Fri May 02, 2014 8:23 am

Re: Difference between dbadmin and psedosuperuser role

Post by keyur_nitc » Mon May 12, 2014 6:25 am

No answer to my question?

Post Reply

Return to “Vertica Security”