Our main sybase server decided to die the other day, so I created a new sybase server along with the databases etc. I then loaded the database dumps into the new database and now one of my users is having the following error message whilst running a script against one of the new databases:-
start
libarbor_db/database_clib.c(7676): ex_servermsg_cb - ERROR, server -
Message number = 10330
Severity = 14
State = 1
Line = 4
Server = 'TSS125'
Procedure = 'check_proc_status'
Message String = EXECUTE permission denied on object check_proc_status, database EUSK11_CUST, owner dbo
Can someone tell me how I reosolve this?
It works fine as the sa user but not as the arbor user which does exist!
start
libarbor_db/database_clib.c(7676): ex_servermsg_cb - ERROR, server -
Message number = 10330
Severity = 14
State = 1
Line = 4
Server = 'TSS125'
Procedure = 'check_proc_status'
Message String = EXECUTE permission denied on object check_proc_status, database EUSK11_CUST, owner dbo
Can someone tell me how I reosolve this?
It works fine as the sa user but not as the arbor user which does exist!