which user did you install Universe as. They become the user with SQL DBA rights.
Check the UV_USERS file which is documented in the SQL Catalog section of the SQLREF guide root needs DBAuth permission to be in this file. Hope this guides you down the right path in resolving and understanding the SQL user setup Neil ________________________________ From: u2-users-boun...@listserver.u2ug.org [u2-users-boun...@listserver.u2ug.org] On Behalf Of Brutzman, Bill [bi...@hkmetalcraft.com] Sent: Wednesday, December 09, 2009 3:58 PM To: U2 Users List Subject: Re: [U2] [UV] BCI Connectivity I found a VMark article... written by Brian Leach... for UniData indicating... Send an eMail to Vmark for UniVerse info. Is the referenced companion article for UniVerse available. I am struggling with setting up BCI on our HP-Ux machine. I have the IBM 10.3 "BASIC SQL Client Interface Guide" but some of the configuration is unClear to me. When I try to connect, I get the following error... # cd /usr/ibm/uv/sql/catalog # /usr/ibm/uv/bin/uv UniVerse Command Language 10.1 (c) Copyright IBM Corporation 2003. All rights reserved. catalog logged on: Wed Dec 9 18:49:15 2009 >GRANT CONNECT TO brutzy SQL+ UniVerse/SQL: root does not have DBA privilege. Also, the settings in >LOGTO UV >uv are unClear. Suggestions would be appreciated. --Bill _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org<mailto:U2-Users@listserver.u2ug.org> http://listserver.u2ug.org/mailman/listinfo/u2-users ________________________________ Total Control Panel Login<https://asp-6.reflexion.net/login?domain=switp.com> To: n...@switp.com<https://asp-6.reflexion.net/address-properties?aID=46755898> From: u2-users-boun...@listserver.u2ug.org<https://asp-6.reflexion.net/address-properties?aID=60327323> Remove<https://asp-6.reflexion.net/FooterAction?ver=1&un-wl-sender-address=1&rID=46755898&aID=60327323> this sender from my allow list You received this message because the sender is on your allow list. _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users