authorize.out

derby database source code.good for you.

ij(C2)> --
-- Verify external scalar function getPermission notices when it is
-- called with a bad id. (should fail.)
values AUTH_TEST.getPermission('***badId');
1                                                                                                                               
--------------------------------------------------------------------------------------------------------------------------------
ERROR XCZ02: Invalid parameter 'userName'='***badId'.
ERROR XCXA0: Invalid identifier.
ij(C2)> values AUTH_TEST.getPermission(null);
1                                                                                                                               
--------------------------------------------------------------------------------------------------------------------------------
ERROR XCZ02: Invalid parameter 'userName'='null'.
ij(C2)> --
-- Verify external scalar function addUserUtility reports an error when called with
-- a bad user, a null user and a bad permission mode and a
-- null permission mode.
call AUTH_TEST.addUserUtility('***badId','READ_ACCESS_PERMISSION');
ERROR XCZ02: Invalid parameter 'userName'='***badId'.
ERROR XCXA0: Invalid identifier.
ij(C2)> call AUTH_TEST.addUserUtility(null,'READ_ACCESS_PERMISSION');
ERROR XCZ02: Invalid parameter 'userName'='null'.
ij(C2)> call AUTH_TEST.addUserUtility('goodUser','badPermission');
ERROR XCZ00: Unknown permission 'badPermission'.
ij(C2)> call AUTH_TEST.addUserUtility('goodUser',null);
ERROR XCZ02: Invalid parameter 'permission'='null'.
ij(C2)> --
-- Add 3 read access users with quoted names and verify they are added.
-- As a negative test we add each user twice
call AUTH_TEST.addUserUtility('"dAda"','READ_ACCESS_PERMISSION');
0 rows inserted/updated/deleted
ij(C2)> call AUTH_TEST.addUserUtility('"dAda"','READ_ACCESS_PERMISSION');
ERROR 28504: Repeated user(s) '"dAda"' in access list 'derby.database.readOnlyAccessUsers';
ij(C2)> call AUTH_TEST.addUserUtility('"bUnny"','READ_ACCESS_PERMISSION');
0 rows inserted/updated/deleted
ij(C2)> call AUTH_TEST.addUserUtility('"bUnny"','READ_ACCESS_PERMISSION');
ERROR 28504: Repeated user(s) '"bUnny"' in access list 'derby.database.readOnlyAccessUsers';
ij(C2)> call AUTH_TEST.addUserUtility('"jAmes"','READ_ACCESS_PERMISSION');
0 rows inserted/updated/deleted
ij(C2)> call AUTH_TEST.addUserUtility('"jAmes"','READ_ACCESS_PERMISSION');
ERROR 28504: Repeated user(s) '"jAmes"' in access list 'derby.database.readOnlyAccessUsers';
ij(C2)> VALUES SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY('derby.database.readOnlyAccessUsers');
1                                                                                                                               
--------------------------------------------------------------------------------------------------------------------------------
"dAda","bUnny","jAmes"                                                                                                          
ij(C2)> VALUES SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY('derby.database.fullAccessUsers');
1                                                                                                                               
--------------------------------------------------------------------------------------------------------------------------------
NULL                                                                                                                            
ij(C2)> --
-- Verify external scalar function setUserUtility reports an error when called with
-- a bad user, a null user, a missing user a bad permission 
-- mode and a null permission mode.
call AUTH_TEST.setUserUtility('***badId','READ_ACCESS_PERMISSION');
ERROR XCZ02: Invalid parameter 'userName'='***badId'.
ERROR XCXA0: Invalid identifier.
ij(C2)> call AUTH_TEST.setUserUtility(null,'READ_ACCESS_PERMISSION');
ERROR XCZ02: Invalid parameter 'userName'='null'.
ij(C2)> call AUTH_TEST.setUserUtility('missingUser','FULL_ACCESS_PERMISSION');
ERROR XCZ01: Unknown user 'missingUser'.
ij(C2)> call AUTH_TEST.setUserUtility('"jAmes"','badPermission');
ERROR XCZ00: Unknown permission 'badPermission'.
ij(C2)> call AUTH_TEST.setUserUtility('"jAmes"',null);
ERROR XCZ02: Invalid parameter 'permission'='null'.
ij(C2)> --
-- Get the access level for our users
values AUTH_TEST.getPermission('"dAda"');
1                                                                                                                               
--------------------------------------------------------------------------------------------------------------------------------
READ_ACCESS_PERMISSION                                                                                                          
ij(C2)> values AUTH_TEST.getPermission('"DADA"');
1                                                                                                                               
--------------------------------------------------------------------------------------------------------------------------------
NULL                                                                                                                            
ij(C2)> --wrong case
values AUTH_TEST.getPermission('"bUnny"');
1                                                                                                                               
--------------------------------------------------------------------------------------------------------------------------------
READ_ACCESS_PERMISSION                                                                                                          
ij(C2)> values AUTH_TEST.getPermission('"dAda"');
1                                                                                                                               
--------------------------------------------------------------------------------------------------------------------------------
READ_ACCESS_PERMISSION                                                                                                          
ij(C2)> --
-- Set all our read access users to full access users twice.
call AUTH_TEST.setUserUtility('"dAda"','FULL_ACCESS_PERMISSION');
0 rows inserted/updated/deleted
ij(C2)> call AUTH_TEST.setUserUtility('"dAda"','FULL_ACCESS_PERMISSION');
0 rows inserted/updated/deleted
ij(C2)> call AUTH_TEST.setUserUtility('"bUnny"','FULL_ACCESS_PERMISSION');
0 rows inserted/updated/deleted
ij(C2)> call AUTH_TEST.setUserUtility('"bUnny"','FULL_ACCESS_PERMISSION');
0 rows inserted/updated/deleted
ij(C2)> call AUTH_TEST.setUserUtility('"jAmes"','FULL_ACCESS_PERMISSION');
0 rows inserted/updated/deleted
ij(C2)> call AUTH_TEST.setUserUtility('"jAmes"','FULL_ACCESS_PERMISSION');
0 rows inserted/updated/deleted
ij(C2)> VALUES SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY('derby.database.readOnlyAccessUsers');
1                                                                                                                               
--------------------------------------------------------------------------------------------------------------------------------
NULL                                                                                                                            
ij(C2)> VALUES SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY('derby.database.fullAccessUsers');
1                                                                                                                               
--------------------------------------------------------------------------------------------------------------------------------
"dAda","bUnny","jAmes"                                                                                                          
ij(C2)> --
-- Verify external scalar function dropUserUtility reports an error when called with
-- a bad user, a null user, a missing user.
call AUTH_TEST.dropUserUtility('***badId');
ERROR XCZ02: Invalid parameter 'userName'='***badId'.
ERROR XCXA0: Invalid identifier.
ij(C2)> call AUTH_TEST.dropUserUtility(null);
ERROR XCZ02: Invalid parameter 'userName'='null'.
ij(C2)> call AUTH_TEST.dropUserUtility('missingUser');
ERROR XCZ01: Unknown user 'missingUser'.
ij(C2)> --
-- Drop each user twice
call AUTH_TEST.dropUserUtility('"dAda"');
0 rows inserted/updated/deleted
ij(C2)> call AUTH_TEST.dropUserUtility('"dAda"');
ERROR XCZ01: Unknown user '"dAda"'.
ij(C2)> call AUTH_TEST.dropUserUtility('"bUnny"');
0 rows inserted/updated/deleted
ij(C2)> call AUTH_TEST.dropUserUtility('"bUnny"');
ERROR XCZ01: Unknown user '"bUnny"'.
ij(C2)> call AUTH_TEST.dropUserUtility('"jAmes"');
0 rows inserted/updated/deleted
ij(C2)> call AUTH_TEST.dropUserUtility('"jAmes"');
ERROR XCZ01: Unknown user '"jAmes"'.
ij(C2)> VALUES SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY('derby.database.readOnlyAccessUsers');
1                                                                                                                               
--------------------------------------------------------------------------------------------------------------------------------
NULL                                                                                                                            
ij(C2)> VALUES SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY('derby.database.fullAccessUsers');
1                                                                                                                               
--------------------------------------------------------------------------------------------------------------------------------
NULL                                                                                                                            
ij(C2)> --
-- Add set and drop some users with names that
-- are not delimited.
call AUTH_TEST.addUserUtility('dada','READ_ACCESS_PERMISSION');
0 rows inserted/updated/deleted
ij(C2)> call AUTH_TEST.addUserUtility('DADA','READ_ACCESS_PERMISSION');
ERROR 28504: Repeated user(s) '"DADA"' in access list 'derby.database.readOnlyAccessUsers';
ij(C2)> -- duplicate
call AUTH_TEST.addUserUtility('bunny','FULL_ACCESS_PERMISSION');
0 rows inserted/updated/deleted
ij(C2)> call AUTH_TEST.addUserUtility('james','FULL_ACCESS_PERMISSION');
0 rows inserted/updated/deleted
ij(C2)> VALUES SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY('derby.database.readOnlyAccessUsers');
1                                                                                                                               
--------------------------------------------------------------------------------------------------------------------------------
dada                                                                                                                            
ij(C2)> VALUES SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY('derby.database.fullAccessUsers');
1                                                                                                                               
--------------------------------------------------------------------------------------------------------------------------------
bunny,james                                                                                                                     
ij(C2)> call AUTH_TEST.setUserUtility('BUNNY','READ_ACCESS_PERMISSION');
0 rows inserted/updated/deleted
ij(C2)> VALUES SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY('derby.database.readOnlyAccessUsers');
1                                                                                                                               
--------------------------------------------------------------------------------------------------------------------------------
dada,BUNNY                                                                                                                      
ij(C2)> VALUES SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY('derby.database.fullAccessUsers');
1                                                                                                                               
--------------------------------------------------------------------------------------------------------------------------------
james                                                                                                                           
ij(C2)> values AUTH_TEST.getPermission('dAda');
1                                                                                                                               
--------------------------------------------------------------------------------------------------------------------------------
READ_ACCESS_PERMISSION                                                                                                          
ij(C2)> values AUTH_TEST.getPermission('bunny');
1                                                                                                                               
--------------------------------------------------------------------------------------------------------------------------------
READ_ACCESS_PERMISSION                                                                                                          
ij(C2)> values AUTH_TEST.getPermission('jaMes');
1                                                                                                                               
--------------------------------------------------------------------------------------------------------------------------------
FULL_ACCESS_PERMISSION                                                                                                          
ij(C2)> call AUTH_TEST.dropUserUtility('dada');
0 rows inserted/updated/deleted
ij(C2)> call AUTH_TEST.dropUserUtility('bunny');
0 rows inserted/updated/deleted
ij(C2)> call AUTH_TEST.dropUserUtility('jaMes');
0 rows inserted/updated/deleted
ij(C2)> VALUES SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY('derby.database.readOnlyAccessUsers');
1                                                                                                                               
--------------------------------------------------------------------------------------------------------------------------------
NULL                                                                                                                            
ij(C2)> VALUES SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY('derby.database.fullAccessUsers');
1                                                                                                                               
--------------------------------------------------------------------------------------------------------------------------------
NULL                                                                                                                            
ij(C2)> -- clean up
drop function AUTH_TEST.getPermission;
0 rows inserted/updated/deleted
ij(C2)> drop procedure AUTH_TEST.verifyAccessRW;
0 rows inserted/updated/deleted
ij(C2)> drop procedure AUTH_TEST.verifyAccessRO;
0 rows inserted/updated/deleted
ij(C2)> drop procedure AUTH_TEST.setUserUtility;
0 rows inserted/updated/deleted
ij(C2)> drop procedure AUTH_TEST.addUserUtility;
0 rows inserted/updated/deleted
ij(C2)> drop procedure AUTH_TEST.dropUserUtility;
0 rows inserted/updated/deleted
ij(C2)>