Re: lose ownership on date base after set derby.database.sqlAuthorization to true

2016-07-11 Thread Rick Hillegas
On 7/11/16 6:07 AM, rsmon wrote: Thank you, but i have created data database via Netbeans and i have created with username testeur and be connected like shows this picture if i pass select * from TESTEUR.CLIENT i obtain

Re: lose ownership on date base after set derby.database.sqlAuthorization to true

2016-07-11 Thread Bryan Pendleton
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

lose ownership on date base after set derby.database.sqlAuthorization to true

2016-07-11 Thread Régis Monfilliette
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

Re: lose ownership on date base after set derby.database.sqlAuthorization to true

2016-07-11 Thread rsmon
Thank you, but i have created data database via Netbeans and i have created with username testeur and be connected like shows this picture if i pass select * from TESTEUR.CLIENT i obtain Error code -1, SQL state 42502: