In a message dated 3/18/2004 3:26:32 AM Pacific Standard Time, [EMAIL PROTECTED] writes:
> Sent: 17 March 2004 19:40 > To: U2 Users Discussion List > Subject: Re: Setting up SQL step 1 > > "Good news (I think) From what I learned - the admin user is set up when you > load the operating system . I was told that if I re-installed my latest > upgrade tape that I could update the user at that time. I never was able to > find any of this documentation on this - and when I asked IBM, since I was > running 9.5 they conveniently told me that this documentation no longer existed - > go figure." Okay remember that on the test server I had said the two UV_USERS were NT Authority\System and Primo\Administrator. The test server is Tregundo and Primo is another server. So now on the test server, we reinstalled Universe 10 and this time it created two UV_USERS as NT Authority\System and Tregundo\Administrator. Now logging on as administrator I was able to GRANT CONNECT to Will.Johnson and also GRANT DBA to Will.Johnson So it seems like two things. One when it was setup initially maybe the server names were subsequently changed and two this was enough to confuse the hell out of SQL. Reinstalling, like you suggested, just reinstalls the UV account, doesn't overwrite files in other accounts and so that worked out fine. And it fixed the UV_USERS file. Another thing I found out was that, only in one obscure location in the documentation (and NOT in the online HELP command documentation) it states that a TRIGGER program must be globally catalogued. I think it also says it can be normally (but not locally) catalogued but that didn't seem to work. On a PICK flavor account you cannot, as far as I could figure globally catalog. I tried what the documentation said and it didn't work. So I had to log to uv, create a Q pointer to the BASIC program file on the other account, then globally catalog it. Also in order for changes to your trigger to take affect you have to DROP TRIGGER, then globally catalog, the CREATE TRIGGER once more. Will "battle scarred" Johnson -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
