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

Hi Rick and Brian, Thank you for your answers that have help me to resolve my problem with database ownership. The source of the problem is that the wizard of Netbeans for create a database always set owner of database APP even if we give a user different user name . In Pj a note ( sorry i

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

Hi Ricks, Thank you for your response. Effectively when i execute select * from sys.sysschemas where schemaName = 'TESTEUR'; i obtain: 278b81cd-0155-d9ce-d86a-12e9eb35 TESTEUR APP The authorized user for the schema is not Testeur. Yet, via netbeans services wizard, i have created the

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

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: