User 'privileges' needed to create table in Universe
Posted: Thu Mar 09, 2006 10:49 pm
Hi,
Can anyone please tell me what 'privileges' a user needs to have in order to create tables within the Ascential Universe?
When I run a Job which uses Universe Stage, (after logging inside as a normal user) the create common inside the Universe fails giving an error "User aa is not an SQL user"
The same Job runs if I log on as an Administrator.
Does this mean all jobs using Ascential Universe must be run using DataStage Administrator?
Poornima
Can anyone please tell me what 'privileges' a user needs to have in order to create tables within the Ascential Universe?
When I run a Job which uses Universe Stage, (after logging inside as a normal user) the create common inside the Universe fails giving an error "User aa is not an SQL user"
The same Job runs if I log on as an Administrator.
Does this mean all jobs using Ascential Universe must be run using DataStage Administrator?
Poornima