Role Membership Table

Database
Enthusiast

Role Membership Table

In Teradata Administrator, if you select a user and right click role membership, you can see all roles the user is member of.

How do you query this in SQL Assistant? What is the query or table?

2 REPLIES 2
Teradata Employee

Re: Role Membership Table

Hi.

 

Check Dbc.RoleMembersV for a "grantee" (user).

 

Cheers.

 

Carlos.

Enthusiast

Re: Role Membership Table

You are a life savior. 

Thank you