DatabaseProcApplicationCreatedLinks
sybsystemprocssp_jdbc_getcolumnprivileges  14 déc. 14Defects Propagation Dependencies

1     
2     create or replace procedure sp_jdbc_getcolumnprivileges(
3         @table_qualifier varchar(32) = null,
4         @table_owner varchar(32) = null,
5         @table_name varchar(300) = null,
6         @column_name varchar(255) = null)
7     AS
8     
9         /* Don't delete the following line. It is the checkpoint for sed */
10        /* Server dependent stored procedure add here ad ADDPOINT_COLPRIVS */
11        exec sp_drv_getcolumnprivileges @table_name, @table_owner, @table_qualifier, @column_name
12    
13    


exec sp_procxmode 'sp_jdbc_getcolumnprivileges', 'AnyMode'
go

Grant Execute on sp_jdbc_getcolumnprivileges to public
go
DEFECTS
 MGTP 3 Grant to public sybsystemprocs..sp_jdbc_getcolumnprivileges  
 MNER 3 No Error Check should check return value of exec 11
 MUCO 3 Useless Code Useless Brackets in create proc 2
 MTR1 2 Metrics: Comments Ratio Comments: 25% 2
 MTR2 2 Metrics: Cyclomatic Complexity Cyclo: 2 = 1dec - 1exi + 2 2
 MTR3 2 Metrics: Query Complexity Complexity: 2 2

DEPENDENCIES
PROCS AND TABLES USED
calls proc sybsystemprocs..sp_drv_getcolumnprivileges  
   reads table sybsystemprocs..sysobjects  
   reads table sybsystemprocs..sysprotects  
   reads table master..sysloginroles (1)  
   reads table master..syssrvroles (1)  
   reads table sybsystemprocs..syscolumns  
   reads table master..sysconfigures (1)  
   writes table sybsystemprocs..sp_drv_getcolumnprivileges_rset_001 
   reads table sybsystemprocs..sysusers