DatabaseProcApplicationCreatedLinks
sybsystemprocssp_odbc_gettableprivileges  14 déc. 14Defects Propagation Dependencies

1     
2     
3     /* Sccsid = '%Z% generic/sproc/src/%M% %I% %G%' */
4     
5     CREATE OR REPLACE PROCEDURE sp_odbc_gettableprivileges(@table_name VARCHAR(255),
6         @table_owner VARCHAR(32) = NULL,
7         @table_qualifier VARCHAR(32) = NULL)
8     AS
9         EXECUTE sp_drv_gettableprivileges @table_name, @table_owner, @table_qualifier
10    


exec sp_procxmode 'sp_odbc_gettableprivileges', 'AnyMode'
go

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

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