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