For now it seems the solution is to create a Cursor which updates the user profile. Please, if there is some other way, respond. Here is the code I used.

DECLARE...

Just some info, the issue is that I need to grant Alter permission to sequences, at this stage it looks like the only way is to grant alter on each...

The suggestion works, only one concern I have is that we need to at minimum create a user on the database even though it does not have rights on the...

Thanks, will test this tomorrow, looks from what I saw in that article that it could be the ownership of the DB's. Will respond tomorrow then.

One question though on...