db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bryan Pendleton <bpendleton.de...@gmail.com>
Subject Re: lose ownership on date base after set derby.database.sqlAuthorization to true
Date Mon, 11 Jul 2016 13:53:12 GMT
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


Mime
View raw message