Archives of the TeradataForum

Message Posted: Thu, 26 Jan 2006 @ 22:20:58 GMT


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

Subj:		Re: Ascential Datastage and dbc.userrights

From:		Anomy Anom

<-- Anonymously Posted: Thursday, January 26, 2006 17:11 -->

We are using the "TeraWrite Operator" that is attempting to do a FastLoad into a work table and it fails immediately with an error stating that the table is not writable, even though the user does have INSERT on the database where the work table resides. Below is the SQL that DataStage is running and not finding the privilege for the given user so it fails.

     select * from dbc.userrights
      where databasename = 'dev07wt' and (tablename = 'histfcst_test' or

      tablename = 'all') and accessright = 'I'

All thoughts appreciated.

Thanks