DatabaseTableApplicationCreatedLinks
mastersysloginroles  14 déc. 14Joins Schema ColumnUsage Queries Writes Propagation 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         predid int null
6     )
7     
8     
9     create clustered index csysloginroles on sysloginroles(-- 2 KB refcount: 44
10        suid
11    )
12    
13    alter table sysloginroles lock datarows
14    
15    Grant Select on sysloginroles to public
16    Grant Select on sysloginroles to sso_role
17    
JOINS
From ColumnsTo TableTo ColumnsCntCstrStrength
[srid]master..syssrvroles[srid]19 FK
[suid]master..syslogins[suid]11 FK
[suid]tempdb..posiblegrants_D3[suid]1 Simple Join
[suid]tempdb..posiblegrants_D3[suid]1 Simple Join

Estimated Index Usage
sysloginroles.csysloginroles clustered(suid)44

ALIASES USED for master..sysloginroles
NO_ALIASlmsrrsrolesysloginroles
268101112

SCHEMA

COLUMN USAGE
suidsp_activeroles  sp_aux_encr_verify_downgrade  sp_aux_securityprofile_getattr  sp_changedbowner  sp_displaylogin  sp_displayroles  sp_drv_getcolumnprivileges  sp_drv_gettableprivileges  sp_helprotect  sp_is_valid_user  sp_locklogin  sp_modifylogin  sp_oledb_getcolumnprivileges  sp_oledb_gettableprivileges 
sridsp_activeroles  sp_aux_encr_verify_downgrade  sp_aux_securityprofile_getattr  sp_changedbowner  sp_displaylogin  sp_displayroles  sp_drv_getcolumnprivileges  sp_drv_gettableprivileges  sp_helprotect  sp_is_valid_user  sp_locklogin  sp_modifylogin  sp_oledb_getcolumnprivileges  sp_oledb_gettableprivileges 
statussp_aux_securityprofile_getattr  sp_displaylogin  sp_modifylogin 

QUERIES
Joined With Links
master..syssrvroles sybsystemprocs..sysusers sybsystemprocs..sp_drv_getcolumnprivileges:274
sybsystemprocs..sp_drv_gettableprivileges:163
sybsystemprocs..sp_drv_gettableprivileges:163
sybsystemprocs..sp_oledb_getcolumnprivileges:190
sybsystemprocs..sp_drv_gettableprivileges:163
sybsystemprocs..sp_oledb_gettableprivileges:235
sybsystemprocs..sp_oledb_gettableprivileges:235
sybsystemprocs..sp_oledb_gettableprivileges:157
sybsystemprocs..sp_oledb_getcolumnprivileges:190
sybsystemprocs..sp_drv_getcolumnprivileges:180
sybsystemprocs..sp_drv_gettableprivileges:259
sybsystemprocs..sp_drv_gettableprivileges:259
sybsystemprocs..sp_oledb_gettableprivileges:157
sybsystemprocs..sp_oledb_getcolumnprivileges:190
sybsystemprocs..sp_drv_getcolumnprivileges:274
sybsystemprocs..sp_drv_getcolumnprivileges:274
sybsystemprocs..sp_oledb_gettableprivileges:157
sybsystemprocs..sp_drv_gettableprivileges:163
sybsystemprocs..sp_drv_getcolumnprivileges:274
sybsystemprocs..sp_drv_getcolumnprivileges:180
sybsystemprocs..sp_oledb_gettableprivileges:235
sybsystemprocs..sp_oledb_getcolumnprivileges:280
sybsystemprocs..sp_oledb_gettableprivileges:157
sybsystemprocs..sp_drv_gettableprivileges:259
sybsystemprocs..sp_drv_gettableprivileges:259
sybsystemprocs..sp_drv_getcolumnprivileges:180
sybsystemprocs..sp_drv_getcolumnprivileges:180
sybsystemprocs..sp_oledb_getcolumnprivileges:190
sybsystemprocs..sp_oledb_getcolumnprivileges:280
sybsystemprocs..sp_oledb_getcolumnprivileges:280
sybsystemprocs..sp_oledb_gettableprivileges:235
sybsystemprocs..sp_oledb_getcolumnprivileges:280
master..syssrvroles sybsystemprocs..sp_displayroles:591
sybsystemprocs..sp_locklogin:362
sybsystemprocs..sp_helprotect:483
sybsystemprocs..sp_helprotect:516
sybsystemprocs..sp_activeroles:118
sybsystemprocs..sp_displayroles:564
sybsystemprocs..sp_activeroles:105
sybsystemprocs..sp_displayroles:607
sybsystemprocs..sp_helprotect:495
tempdb..posiblegrants_D3 master..syssrvroles sybsystemprocs..sysusers sybsystemprocs..sp_drv_getcolumnprivileges:178
sybsystemprocs..sp_oledb_getcolumnprivileges:188
sybsystemprocs..sp_drv_getcolumnprivileges:178
sybsystemprocs..sp_drv_getcolumnprivileges:178
sybsystemprocs..sp_oledb_getcolumnprivileges:188
sybsystemprocs..sp_oledb_getcolumnprivileges:188
master..syslogins sybsystemprocs..sp_locklogin:728
sybsystemprocs..sp_locklogin:632
sybsystemprocs..sp_locklogin:691
sybsystemprocs..sp_locklogin:639
sybsystemprocs..sp_aux_encr_verify_downgrade:238
master..syslogins sybsystemprocs..sp_locklogin:698
sybsystemprocs..sp_locklogin:721

COLUMN WRITES detailed
ColumnWritten From
status    sysloginroles.status   sp_modifylogin.@?  

DATA PROPAGATION detailed
ColumnWritten To
statussysloginroles.status  

DEPENDENCIES
READERS AND WRITERS
read by proc sybsystemprocs..sp_changedbowner  
read by proc sybsystemprocs..sp_activeroles  
read by proc sybsystemprocs..sp_displayroles  
read by proc sybsystemprocs..sp_aux_encr_verify_downgrade  
read by proc sybsystemprocs..sp_displaylogin  
read by proc sybsystemprocs..sp_oledb_gettableprivileges  
read by proc sybsystemprocs..sp_oledb_getcolumnprivileges  
read by proc sybsystemprocs..sp_helprotect  
read by proc sybsystemprocs..sp_drv_getcolumnprivileges  
   called by proc sybsystemprocs..sp_jdbc_getcolumnprivileges  
   called by proc sybsystemprocs..sp_odbc_getcolumnprivileges  
read by proc sybsystemprocs..sp_is_valid_user  
   called by proc sybsystemprocs..sp_plan_dbccdb  
read by proc sybsystemprocs..sp_locklogin  
   called by proc sybsystemprocs..sp_addlogin  
read_written by proc sybsystemprocs..sp_modifylogin  
read by proc sybsystemprocs..sp_aux_securityprofile_getattr  
   called by proc sybsystemprocs..sp_securityprofile  
read by proc sybsystemprocs..sp_drv_gettableprivileges  
   called by proc sybsystemprocs..sp_odbc_gettableprivileges  
   called by proc sybsystemprocs..sp_jdbc_gettableprivileges