User 'privileges' needed to create table in Universe

[poornimajayan]

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

[ArndW]

The internal SQL privileges in a datastage project are assigned per the normal user access mechanism of DataStage (i.e. the .developer.adm file). If you run the job as a DataStage user it will go through, but I am assuming your userid with which you are running is not enabled for DataStage use.

[ray.wurlod]

You need to find out who the DBA is.

Code: Select all

SELECT * FROM UV_USERS WHERE DBAAUTH = 'YES';

Connect (via telnet or Administrator client Command window) as that user and issue CONNECT privilege to that user.
GRANT CONNECT TO aa;
You will also need to add entries to the UV.LOGINS table to map all the different ways that user aa is known onto this user, or issue separate grants to the alternate IDs.

Code: Select all

GRANT CONNECT TO machine\aa;
GRANT CONNECT TO domain\aa;

That having been done, if the table already exists, the DBA may need to grant appropriate table privileges.

Code: Select all

GRANT SELECT, INSERT, UPDATE, DELETE, ALTER ON table TO PUBLIC;

[Developer]

I have run into this same problem. One of the first things you can do is look at the permissions of the project folder. But the best way to verify who can have access to create Universe is by runni...

[roy]

Hi,
What exactly are you trying to do?