|
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=foxhound2;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=foxhound2;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?
|