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 |