db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From rsmon <regis.monfillie...@wanadoo.fr>
Subject Re: lose ownership on date base after set derby.database.sqlAuthorization to true
Date Mon, 11 Jul 2016 13:07:21 GMT
Thank you, but i have created data database via Netbeans and i have created
with username testeur 
and be connected like shows this picture
<http://apache-database.10148.n7.nabble.com/file/n146431/BaseTest.png>   

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.

Mime
View raw message