Hello:
I've searched on other sites, googled for it and I still can't find the answer.
I've created 3 databases on an Informix instance. Using a remote SQL client I can connect to all of them using the informix user. I cannot, however, connect to any of those using a new user I've created: DEV_USER.
Informix is installed on Windows 2003.
1) I've created the DEV_USER on Windows and assigned to groups Users and Informix-Admin
2) Using the Informix user, I connected to the database INFORMIX_DEV and ran:
GRANT DBA TO DEV_USER;
I've received a message: "PERMISSION GRANTED"
3) I'm keep getting the "No connect permission" message when trying to connect either from a remote SQL or a local command line.
Am I missing something?
Alejandro