Problems initiating SQL in a new database

D

dlangschied

Member
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?
 
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
 
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!
 
You must log in or register to reply here.
Back
Top