Foxhound 3.0 FAQ
Foxhound 3.0 FAQ Home      Foxhound Home      RisingRoad           Breck.Carter@gmail.com     


Question: How do I change the ADHOC password?

Answer:

Use dbisql to connect to the Foxhound database with the original password for the ADHOC user id...

-c "ENG=foxhound3;DBN=f;UID=ADHOC;PWD=SQL"
...then use the GRANT CONNECT command to change the password:
GRANT CONNECT TO ADHOC IDENTIFIED BY 'JqDCt64Kfy73';
Now you can use the new password to connect:
-c "ENG=foxhound3;DBN=f;UID=ADHOC;PWD=JqDCt64Kfy73"

See also...
How do I run adhoc queries on the Foxhound database?
How do I see the schema for adhoc reporting?


This page was last updated on November 3, 2011.      Foxhound 3.0 FAQ Home      Foxhound Home      RisingRoad      Breck.Carter@gmail.com