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
Difference between dbadmin and psedosuperuser role
Moderator: NorbertKrupa
-
- Newbie
- Posts: 5
- Joined: Fri May 02, 2014 8:23 am
Re: Difference between dbadmin and psedosuperuser role
Hi!
[DELETED]
[DELETED]
Last edited by id10t on Wed May 06, 2015 5:23 pm, edited 1 time in total.
-
- Newbie
- Posts: 5
- Joined: Fri May 02, 2014 8:23 am
Re: Difference between dbadmin and psedosuperuser role
Thanks for the information.
But using PSEUDOSUPERUSER, one can grant oneself the dbadmin role and voila..!
But using PSEUDOSUPERUSER, one can grant oneself the dbadmin role and voila..!
-
- Newbie
- Posts: 5
- Joined: Fri May 02, 2014 8:23 am
Re: Difference between dbadmin and psedosuperuser role
You're wrong here. PSEUDOSUPERUSER can create and alter user.!!!sKwa wrote:Not exactly. PSEUDOSUPERUSER can't create user, for example.
Re: Difference between dbadmin and psedosuperuser role
Hi!
[DELETED]
[DELETED]
Last edited by id10t on Wed May 06, 2015 5:23 pm, edited 1 time in total.
-
- Newbie
- Posts: 5
- Joined: Fri May 02, 2014 8:23 am
Re: Difference between dbadmin and psedosuperuser role
Wrong again . one can create users too. We should try and run the commands rather just interpreting the docs.keyur_nitc wrote:alter ok, create should not: https://my.vertica.com/docs/7.0.x/HTML/ ... ERRole.htm
-
- Newbie
- Posts: 5
- Joined: Fri May 02, 2014 8:23 am
Re: Difference between dbadmin and psedosuperuser role
No answer to my question?