db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rick Hillegas <rick.hille...@gmail.com>
Subject Re: lose ownership on date base after set derby.database.sqlAuthorization to true
Date Tue, 12 Jul 2016 01:14:54 GMT
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
> <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.
>
Hi R├ęgis,

What do you see when you issue this query:

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

Thanks,
-Rick

Mime
View raw message