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
User 'privileges' needed to create table in Universe
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 16
- Joined: Sun Apr 17, 2005 11:27 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You need to find out who the DBA is.
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.
That having been done, if the table already exists, the DBA may need to grant appropriate table privileges.
Code: Select all
SELECT * FROM UV_USERS WHERE DBAAUTH = 'YES';
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;
Code: Select all
GRANT SELECT, INSERT, UPDATE, DELETE, ALTER ON table TO PUBLIC;
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
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...
<br>
Have you tried Searching before posting? Yep, but all of the answers are now blocked - Grrrr.<br>
Looked at any recent posts in case they're your problem? Yep, but they are blocked - Grrrr.<br>
Have you tried Searching before posting? Yep, but all of the answers are now blocked - Grrrr.<br>
Looked at any recent posts in case they're your problem? Yep, but they are blocked - Grrrr.<br>
Hi,
What exactly are you trying to do?
What exactly are you trying to do?
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
![Image](http://www.worldcommunitygrid.org/images/logo.gif)
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
![Image](http://www.worldcommunitygrid.org/images/logo.gif)