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 Tue, 12 Jul 2016 07:23:25 GMT
Hi Ricks,

Thank you for your response.

Effectively when i execute select * from sys.sysschemas where schemaName =
'TESTEUR'; 
i obtain: 278b81cd-0155-d9ce-d86a-000012e9eb35	TESTEUR	APP
The authorized user for the schema is not Testeur.
Yet, via netbeans services wizard, i have created the database
BaseTestDroits with user name Testeur and a password  and the result is a
database with shema Testeur ( an also App) but  the schema Testeur have app
for authorized user. How can i connect as owner of database App?

I have succeded like this 

1) create a database with the netbeans wizard BddTest1 without user but a
passwd ( admin ) 
2) connect this data base with Netbeans
services->databases->drivers-javadb(Network)->connect using
    set only the passwd admin

3)
    CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.user.uSCH', 'y');
    create schema SCH authorization uSCH;
    CALL
SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.database.sqlAuthorization','true');

4) RESTART  SGBD SERVER and  Connexion  uSCH/y" 

5)  create table SCH.Client( numcli int primary key, nomcli varchar(30));
     insert into  SCH.Client values(1,'Dupont Jean');
     insert into  SCH.Client values(2,'Leroux Martin');
     grant select on SCH.Client to pierre;
 
6) Connect to database  without user but password admin

7) CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.user.pierre', 'z');

8) Connect with pierre/z

9) select * from SCH.CLIENT

      NUMCLI	NOMCLI
          1	Dupont Jean
          2	Leroux Martin

 Regards




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

Mime
View raw message