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

On 7/12/2016 7:01 PM, Rick Hillegas wrote: Effectively when i execute select * from sys.sysschemas where schemaName ='TESTEUR'; i obtain: 278b81cd-0155-d9ce-d86a-12e9eb35TESTEURAPP As you note, this indicates that the database is owned by APP. Hi Rick, In your opinion, is

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

Hi Régis, More responses inline... On 7/12/16 12:23 AM, rsmon wrote: 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 As you note, this indicates that the

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

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

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:

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

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