DatabaseProcApplicationCreatedLinks
sybsystemprocssp_ijdbc_getschemas  31 Aug 14Defects Dependencies

1     
2     /* 
3     **  sp_ijdbc_getschemas
4     */
5     
6     CREATE PROCEDURE sp_ijdbc_getschemas
7     as
8     
9         if @@trancount = 0
10        begin
11            set chained off
12        end
13    
14        set transaction isolation level 1
15    
16    
17        delete #tmp_getschemas
18    
19        insert #tmp_getschemas
20        select TABLE_SCHEM = name from sysusers where suid >= - 2 order by name
21    
22    


exec sp_procxmode 'sp_ijdbc_getschemas', 'AnyMode'
go

Grant Execute on sp_ijdbc_getschemas to public
go
DEFECTS
 MGTP 3 Grant to public sybsystemprocs..sp_ijdbc_getschemas  
 MGTP 3 Grant to public sybsystemprocs..sysusers  
 MNER 3 No Error Check should check @@error after delete 17
 MNER 3 No Error Check should check @@error after insert 19
 QISO 3 Set isolation level 14
 MTR1 2 Metrics: Comments Ratio Comments: 5% 6
 MTR2 2 Metrics: Cyclomatic Complexity Cyclo: 2 = 1dec - 1exi + 2 6
 MTR3 2 Metrics: Query Complexity Complexity: 11 6

DEPENDENCIES
PROCS AND TABLES USED
reads table sybsystemprocs..sysusers  
writes table tempdb..#tmp_getschemas (1)