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

[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
Error code -1, SQL state 42502: L'utilisateur 'TESTEUR' ne dispose pas de
droits SELECT sur la colonne 'NUMCLI' de la table 'TESTEUR'.'CLIENT'.

if i pass Grant select on TESTEUR.CLIENT to TESTEUR I obtain:

Error code -1, SQL state 42506: L'utilisateur 'TESTEUR' n'est pas
propriétaire de Table/View 'TESTEUR'.'CLIENT'.



--
View this message in context: 
http://apache-database.10148.n7.nabble.com/lose-ownership-on-date-base-after-set-derby-database-sqlAuthorization-to-true-tp146429p146431.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.


Hi Régis,

What do you see when you issue this query:

  select * from sys.sysschemas where schemaName = 'TESTEUR';

Thanks,
-Rick

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

[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: L'utilisateur 'TESTEUR' ne dispose pas de
droits SELECT sur la colonne 'NUMCLI' de la table 'TESTEUR'.'CLIENT'.

if i pass Grant select on TESTEUR.CLIENT to TESTEUR I obtain:

Error code -1, SQL state 42506: L'utilisateur 'TESTEUR' n'est pas
propriétaire de Table/View 'TESTEUR'.'CLIENT'.



--
View this message in context: 
http://apache-database.10148.n7.nabble.com/lose-ownership-on-date-base-after-set-derby-database-sqlAuthorization-to-true-tp146429p146431.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.

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

[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 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

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

[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 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.