Hi,
I am working on building query which will compare "Rights Held by Database1" with "Rights Held by Database2". 
Can anyone please suggest what should be the desired query?
 
Thanks in Advance,
Mihir

Hello

Let's say that i have  a database D1_DQ for which there are a number of roles with rights assigned on it like the ones below: 

GRANT DROP VIEW ON "D1_DQ" TO "RL_DQ_BAR";

GRANT CREATE TABLE ON "D1_DQ" TO "RL_DQ_BAR";

GRANT DROP VIEW ON "D1_DQ" TO "RL_DQ_BAR";

Hello guys,
 
I am trying to find out a solution/an answer for my problem for some days and my conclusion (till now) is this one: it's possible to grant access for a schema to a role, but nor for its (schema's) content. Please correct me if I am wrong. 
 
Here is my problem:
 

Hi,
We received a request from customer, whether we can integrate the Active Directory permissions with Teradata Roles. What they are looking for is -

Hi,
What do you guys recommend, are the best practices on creating Roles and Profiles?
Right now I have 9 different roles according to user's resposibilities, rights and environment, and clearly most of them must have different priority.  So I created 9 profiles, one for each role. 

Hi All,

What is the best way to move users,roles,profiles from one system to another. We have a client who has got new 2690 box and wanted to do some data movement from Prod to 2690 box.