Problems initiating SQL in a new database

[dlangschied]

I am having issues with my OE 10.1C database and creation of an SQL DBA user. This is for QAD's EAM report user eamrpt. I performed the following functions using sqlexp on Linux as root (the db creator):

create user 'eamrpt','eamrpt';
commit;
grant dba to eamrpt;
commit;
quit

After performing this, I tried to run sqlexp as user eamrpt and i get an access denied (authorisation failed) error. I logged into the database as eamrpt and displayed the sysdbauth table and their were no entries.

Any ideas as to what happened?

 

[vinod_home]

what do you get if you dont quit after granting dba priviledges to eamrpt user and do a select from sysdbauth table after the commit. Do you see eamrpt as dba user.

select * from sysprogress.sysdbauth;

HTH

 

[dlangschied]

I was able to get the issue fixed.

I deleted the user in the Progress database. Then I dropped the user as root. I created the user anew and granted dba to it. Now all is good in the SQL world. I do not know particularly why the issue came about, but I needed to get past it.

Thanks for the assistance!