Skip to Content
0

ASE 15.7 to ASE 16 SP 03 upgrade issues

Sep 25, 2017 at 12:51 PM

92

avatar image

We've been running ASE 15.7 for years now, but have now finally decided to start the ASE 16 upgrade project. So I've made two different test installations so far ;

1.Installed ASE 16 SP03 from scratch, built my ASE and loaded a full dump - OK

2.Installed ASE 15.7, built my ASE and loaded a full dump, then installed ASE 16 SP03 and ran the sqlupgrade utility - OK

So we had a go last week for our first test and development server. Installed ASE16 SP03, started to upgrade the three ASE's on that server with the sqlupgrade utility and they all went fine (we thought).

When the developers and testers started to run against the ASE's we got "permission issues" on a couple of tables, examples below :

Caused by: java.sql.SQLException: INSERT permission denied on object w#curr_assort_irt, database sbnwork, owner dbo
Caused by: java.sql.SQLException: INSERT permission denied on object w#curr_assort_model, database sbnwork, owner dbo
Caused by: java.sql.SQLException: SELECT permission denied on object s#cact, database sbnint, owner dbo

So we checked the tables with sp_helprotect but they all looked the same there as they did comparing them to production ?

So far we have only found a hand full of tables behaving like this on all three of our test/dev ASE's but NOT on the two test ASE's I did prior to this upgrade...

The workaround is to either recompile the stored procedure that is running against the table or to grant "whatever" is needed on the table.

We have made some tests, running the stored procs as "sa" and then there is no permission problem with the tables, but when we run them as they should run with the correct users, we get "permission denied".

Has anyone any idea of what might be wrong here, if it could be caused by the upgrade to ASE 16 SP03 or have you hit these kind of problems before ?

My fear is that there is more than meet the eye here !

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

avatar image
Former Member Mar 11 at 05:37 AM
0

Are they entering the ‘sa’ account?

Share
10 |10000 characters needed characters left characters exceeded