求教:执行shell脚本后,访问不了informix数据库why?

zhaohaha112

shell脚本中有以下语句:
        echo "execute procedure month();" >exec.sql
        echo "unload to clpps"$DATE".unl select callingNumber, cost from CHARGELOG where (chargeType = 2 or chargeType = 15  or chargeType = 16 )        and callingUserType = '2' and Callbegintime like '$MONTH%' " >> exec.sql
        dbaccess $IIPDBNAME exec.sql 1>>$LOGNAME 2>&1

然后就进不去了,怎么回事啊?

请教:是不是文件名exec.sql出了错啊?

zhaohaha112

dbaccess 后连接数据库时,出现without connect perminssion(大概这个意思吧,详细的不太清楚了)错误!


后来发现需要grant dba to pubilc;然后再revoke dba from pubic;
然后再grant dba to myuser;才又可以访问的.

求大侠指点到底怎么回事?