DatabaseTableApplicationCreatedLinks
mastersyssrvroles  14 déc. 14Joins Schema ColumnUsage Queries Writes Propagation Dependencies

1     create table syssrvroles(-- 0 Rows, Data: 2 KB, Index: 2 KB
2         srid int not null,
3         name varchar(30) not null,
4         password varbinary(128) null,
5         pwdate datetime null,
6         status smallint null,
7         logincount smallint null,
8         locksuid int null,
9         lockreason int null,
10        lockdate datetimn null
11    )
12    
13    
14    create unique clustered index csyssrvroles on syssrvroles(-- 2 KB refcount: 96
15        srid
16    )
17    
18    alter table syssrvroles lock datarows
19    
20    Grant Select on syssrvroles to public
21    Grant Select on syssrvroles to sso_role
22    
JOINS
From ColumnsTo TableTo ColumnsCntCstrStrength
[srid]master..sysloginroles[srid]19 Rev FK
[name]sybsystemprocs..sysusers[name]10 FK
[srid]sybsystemprocs..sysroles[id]9 Rev FK
[srid]master..spt_values[number]1 Rev FK
[srid]master..sysattributes[object_info2]1 Rev FK

Estimated Index Usage
syssrvroles.csyssrvroles unique clustered(srid)96

ALIASES USED for master..syssrvroles
NO_ALIASarrolenamesrvrosyssrvroles
26191910

SCHEMA

COLUMN USAGE
sridsp_activeroles  sp_addexternlogin  sp_addgroup  sp_changedbowner  sp_displaylogin  sp_displayroles  sp_dropexternlogin  sp_drv_getcolumnprivileges  sp_drv_gettableprivileges  sp_fix_dtm_ha_roles  sp_helpexternlogin  sp_helprotect  sp_ijdbc_stored_procedures  sp_locklogin  sp_modifystats  sp_odbc_stored_procedures  sp_odbc_tables  sp_oledb_getcolumnprivileges  sp_oledb_gettableprivileges  sp_oledb_stored_procedures  sp_oledb_tables  sp_oledb_views  sp_stored_procedures  sp_tables 
namesp_activeroles  sp_addexternlogin  sp_addgroup  sp_addlogin  sp_adduser  sp_changegroup  sp_displaylogin  sp_displayroles  sp_dropexternlogin  sp_dropgroup  sp_drv_getcolumnprivileges  sp_drv_gettableprivileges  sp_fix_dtm_ha_roles  sp_helpexternlogin  sp_helpgroup  sp_helprotect  sp_helpuser  sp_ijdbc_stored_procedures  sp_locklogin  sp_modifystats  sp_odbc_stored_procedures  sp_odbc_tables  sp_oledb_getcolumnprivileges  sp_oledb_gettableprivileges  sp_oledb_stored_procedures  sp_oledb_tables  sp_oledb_views  sp_passwordpolicy  sp_stored_procedures  sp_tables 
passwordsp_displayroles  sp_fix_dtm_ha_roles  sp_passwordpolicy 
pwdatesp_displayroles 
statussp_displayroles 
logincountsp_displayroles 
locksuidsp_displayroles 
lockreasonsp_displayroles 
lockdatesp_displayroles 

QUERIES
Joined With Links
sybsystemprocs..sysobjects sybsystemprocs..sysprotects sybsystemprocs..sysroles sybsystemprocs..sp_oledb_views:313
sybsystemprocs..sp_stored_procedures:228
sybsystemprocs..sp_odbc_stored_procedures:209
sybsystemprocs..sp_ijdbc_stored_procedures:204
sybsystemprocs..sp_oledb_tables:371
sybsystemprocs..sp_tables:353
sybsystemprocs..sp_oledb_stored_procedures:212
sybsystemprocs..sp_odbc_tables:332
master..sysloginroles 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..sysloginroles 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
master..sysloginroles tempdb..posiblegrants_D3 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..sysattributes master..sysservers sybsystemprocs..sp_helpexternlogin:160
sybsystemprocs..sysprotects sybsystemprocs..sysroles sybsystemprocs..sp_modifystats:274

COLUMN WRITES detailed
ColumnWritten From
srid    sp_fix_dtm_ha_roles.@?  
name    sp_fix_dtm_ha_roles.@?  
password    sp_fix_dtm_ha_roles.@?  

DATA PROPAGATION detailed
ColumnWritten To
namesp_activeroles_rset_001.Role Name sp_activeroles_rset_002.Role Name sp_displayroles_rset_001.Role Name sp_displayroles_rset_002.Role Name sp_displayroles_rset_003.Role Name sp_displayroles_rset_004.Role Name
sridsysattributes.object_info2   °.char_value   sysattributes.object_info2   °.int_value   °.char_value   sp_dropdevice_rset_001.device sp_dropdevice_rset_001.device sp_forceonline_object_rset_001.Index °.status sp_forceonline_object_rset_002.Index
°.status sp_forceonline_page_rset_001.status sp_forceonline_page_rset_002.status sp_listsuspect_object_rset_001.Index °.Access sp_listsuspect_page_rset_001.Index °.Access sp_makesuspect_obj_rset_001.Indid °.LogType °.PageType
°.ErrType °.Delay °.TotalNum sp_makesuspect_obj_rset_002.Indid °.LogType °.PageType °.ErrType °.Delay °.TotalNum sp_makesuspect_obj_rset_003.Indid
°.LogType °.PageType °.ErrType °.Delay °.TotalNum sp_passwordpolicy_rset_001.message sp_passwordpolicy_rset_002.value sp_passwordpolicy_rset_003.value sp_passwordpolicy_rset_004.Policy_option sp_rjs_retrieve_rset_001.host_name
sp_setsuspect_granularity_rset_001.Online mode sp_setsuspect_threshold_rset_001.Cfg. Suspect threshold sp_setsuspect_threshold_rset_002.Cfg. Suspect Threshold sp_ssladmin_rset_001.certificate_path sp_ssladmin_rset_002.Cipher Suite Name °.Preference

DEPENDENCIES
READERS AND WRITERS
read by proc sybsystemprocs..sp_addlogin  
read by proc sybsystemprocs..sp_odbc_stored_procedures  
read by proc sybsystemprocs..sp_changegroup  
read by proc sybsystemprocs..sp_dropgroup  
read by proc sybsystemprocs..sp_oledb_stored_procedures  
read by proc sybsystemprocs..sp_activeroles  
read by proc sybsystemprocs..sp_displayroles  
read by proc sybsystemprocs..sp_addgroup  
read by proc sybsystemprocs..sp_helpuser  
read by proc sybsystemprocs..sp_passwordpolicy  
   called by proc sybsystemprocs..sp_downgrade  
read by proc sybsystemprocs..sp_modifystats  
read by proc sybsystemprocs..sp_stored_procedures  
read by proc sybsystemprocs..sp_oledb_views  
read by proc sybsystemprocs..sp_helpexternlogin  
read by proc sybsystemprocs..sp_helprotect  
read by proc sybsystemprocs..sp_locklogin  
   called by proc sybsystemprocs..sp_addlogin  
read by proc sybsystemprocs..sp_ijdbc_stored_procedures  
read by proc sybsystemprocs..sp_oledb_gettableprivileges  
read by proc sybsystemprocs..sp_addexternlogin  
read by proc sybsystemprocs..sp_adduser  
read_written by proc sybsystemprocs..sp_fix_dtm_ha_roles  
read by proc sybsystemprocs..sp_displaylogin  
read by proc sybsystemprocs..sp_helpgroup  
   called by proc sybsystemprocs..sp_helpuser  
read by proc sybsystemprocs..sp_drv_getcolumnprivileges  
   called by proc sybsystemprocs..sp_odbc_getcolumnprivileges  
   called by proc sybsystemprocs..sp_jdbc_getcolumnprivileges  
read by proc sybsystemprocs..sp_drv_gettableprivileges  
   called by proc sybsystemprocs..sp_odbc_gettableprivileges  
   called by proc sybsystemprocs..sp_jdbc_gettableprivileges  
read by proc sybsystemprocs..sp_changedbowner  
read by proc sybsystemprocs..sp_tables  
read by proc sybsystemprocs..sp_odbc_tables  
read by proc sybsystemprocs..sp_oledb_tables  
read by proc sybsystemprocs..sp_oledb_getcolumnprivileges  
read by proc sybsystemprocs..sp_dropexternlogin