On 7/11/2016 6:07 AM, Régis Monfilliette wrote:
|Hi,||I have lose ownership on database after i have passed the command: | |CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.database.sqlAuthorization', 'true');| I have restart the data base, and then connect on same user( TESTEUR) i have created a table but i can't pass any command ( select or grant) i received the message: Error code -1, SQL state 42506: L'utilisateur 'TESTEUR' n'est pas propriétaire de Table/View 'TESTEUR'.'CLIENT'. Someone can help me? Thank you.
Perhaps user TESTEUR wasn't actually the database owner? https://db.apache.org/derby/docs/10.12/security/cseccsecuredbowner.html Perhapps user APP is actually the database owner? bryan
