Database | Table | Application | Created | Links |
master | sysloginroles ![]() | ![]() | 31 Aug 14 | Joins Schema ColumnUsage Queries Dependencies |
1 create table sysloginroles(-- 0 Rows, Data: 2 KB, Index: 4 KB 2 suid int not null, 3 srid int not null, 4 status smallint not null 5 ) 6 7 create clustered index csysloginroles on sysloginroles(-- 2 KB refcount: 33 8 suid 9 ) 10 11 alter table sysloginroles lock datarows 12 13 Grant Select on sysloginroles to sso_role 14
JOINS | ||||||||||||||||||
|
Estimated Index Usage | |
sysloginroles.csysloginroles clustered(suid) | 33 |
ALIASES USED for master..sysloginroles | |||||
NO_ALIAS | l | msr | r | srole | sysloginroles |
24 | 8 | 10 | 1 | 1 | 3 |
SCHEMA |
![]() |
DEPENDENCIES |
READERS AND WRITERS read by proc sybsystemprocs..sp_aux_securityprofile_getattr ![]() called by proc sybsystemprocs..sp_securityprofile ![]() read by proc sybsystemprocs..sp_displayroles ![]() written by proc sybsystemprocs..sp_droplogin ![]() read by proc sybsystemprocs..sp_activeroles ![]() read by proc sybsystemprocs..sp_is_valid_user ![]() called by proc sybsystemprocs..sp_optimal_text_space ![]() called by proc sybsystemprocs..sp_chgattribute ![]() called by proc sybsystemprocs..sp_plan_dbccdb ![]() read by proc sybsystemprocs..sp_locklogin ![]() called by proc sybsystemprocs..sp_droplogin ![]() called by proc sybsystemprocs..sp_addlogin ![]() read by proc sybsystemprocs..sp_changedbowner ![]() read by proc sybsystemprocs..sp_helprotect ![]() read_written by proc sybsystemprocs..sp_modifylogin ![]() read by proc sybsystemprocs..sp_aux_encr_verify_downgrade ![]() read by proc sybsystemprocs..sp_displaylogin ![]() |