Database | Proc | Application | Created | Links |
sybsystemprocs | sp_revokelogin | 31 Aug 14 | Defects Dependencies |
1 2 create proc sp_revokelogin 3 @col1 varchar(60) = NULL 4 as 5 6 declare @msg varchar(255) 7 8 /* 9 ** check if user has sso role, proc_role will also do auditing 10 ** if required. proc_role will also print error message if required. 11 */ 12 13 if (proc_role("sso_role") = 0) 14 return (1) 15 16 dbcc iseadmin("revokelogin", @col1) 17 18 /* if no error, report success */ 19 if @@error = 0 20 begin 21 /* 22 ** 18070, "Access revoked." 23 */ 24 exec sp_getmessage 18070, @msg output 25 print @msg 26 return (0) 27 end 28 29 /* 30 ** If there was an error, the specific message was already sent to client 31 ** within the iseadmin() module. 32 */ 33 34 return (1) 35 36 /* end of sp_revokelogin */ 37
DEFECTS | |
MNER 3 No Error Check should check return value of exec | 24 |
MUCO 3 Useless Code Useless Brackets | 13 |
MUCO 3 Useless Code Useless Brackets | 14 |
MUCO 3 Useless Code Useless Brackets | 26 |
MUCO 3 Useless Code Useless Brackets | 34 |
MTR1 2 Metrics: Comments Ratio Comments: 44% | 2 |
MTR2 2 Metrics: Cyclomatic Complexity Cyclo: 2 = 2dec - 2exi + 2 | 2 |
MTR3 2 Metrics: Query Complexity Complexity: 12 | 2 |
DEPENDENCIES |
PROCS AND TABLES USED calls proc sybsystemprocs..sp_getmessage reads table sybsystemprocs..sysusermessages reads table master..sysmessages (1) reads table master..syslanguages (1) calls proc sybsystemprocs..sp_validlang reads table master..syslanguages (1) |