Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 26 Jan 2006 @ 17:58:49 GMT


     
  <Prev Next>  
<<First
<Prev
Next> Last>>  


Subj:   Ascential Datastage and dbc.userrights
 
From:   Anomy Anom

<-- Anonymously Posted: Thursday, January 26, 2006 12:00 -->

Has anyone encountered any issues with the Datastage ETL tool attempting to verify user permissions in Teradata?

The issue we are having is that we granted all the necessary permissions in Teradata, to the users via Roles. Unfortunately, the Datastage tool is attempting to read the dbc.userrights view and is looking to see if the user has Insert on the specific database.tablename that they are attempting to insert into. It does not find that privilege there and fails the request, since all of our privileges are granted at the database level and through a Role.

I think it's a bug in Datastage or maybe there is a way to disable this verification step and allow Teradata to manage the security. I have an incident open with IBM but I wanted to see if there were any other Teradata customers that had overcome this issue and how.

Thanks in advance for any feedback!



     
  <Prev Next>  
<<First
<Prev
Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016