The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

LDAP Roles - Privileges

Hello to all,

We implemented LDAP Auth on our Vertica Environment. Before LDAP we have user (password auth) on Vertica and we want to use both these users. For LDAP user; they have the role that they have at LDAP side as security group.

So this is the case:

LDAP Side:
Security Group 'Vertica Users'
User1
User2

Vertica Side Before LDAP sync:
ETL_User

Vertica Side After LDAP sync:
User1 with role 'Vertica Users'
User2 with role 'Vertica Users'
ETL_User with role 'Vertica Users' (we granted role 'Vertica Users' to ETL_User)

So I try to manage that in schemas already been created by ETL_User; (i.e owned by ETL_User)
User1 and User2 can create tables; (I managed this)
User1 can drop tables owned by User2 and vice versa; (I could not)
User1 can alter tables owned by User2 and vice versa; (I could not)
ETL_user can drop tables owned by User1 andUser2(I managed this)
User1 and Users2 can drop tables owned by ETL_User (I could not)

Is there a way?

Thank you.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.