Teradata Roles Based Privileges And User Based Privileges

General

Teradata Roles Based Privileges And User Based Privileges

Hello,

Looking for some advise,

Traditionally in our data warehouse we have given access rights to the users due to the company at the time being small over time the comapny has changed but the process it which we give user rights has not. When I joined the company I was new to teradata and a team of people required the same access I sugguested using a Teradata Role. 

My question is does user base privileges still work if the user is assigned to a role? 

Thanks

Tags (1)
2 REPLIES
Teradata Employee

Re: Teradata Roles Based Privileges And User Based Privileges

Yes. Any privileges provided via role(s) are in addition to any privileges granted specifically to the user.

Re: Teradata Roles Based Privileges And User Based Privileges

Thank You Fred