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

1     create table sysusers(-- 1 Rows, Data: 2 KB, Index: 8 KB
2         suid int not null,
3         uid int not null,
4         gid int not null,
5         name sysname not null,
6         environ varchar(255) null
7     )
8     
9     
10    create unique index ncsysusers1 on sysusers(-- 2 KB refcount: 115
11        name
12    )
13    create unique index ncsysusers2 on sysusers(-- 2 KB refcount: 88
14        uid
15    )
16    create clustered index csysusers on sysusers(-- 2 KB refcount: 134
17        suid
18    )
19    
20    alter table sysusers lock datarows
21    
22    Grant Select on sysusers to public
23    
JOINS
From ColumnsTo TableTo ColumnsCntCstrStrength
[gid]sybsystemprocs..sysprotects[uid]13 Simple Join
[name]master..syssrvroles[name]10 Rev FK
[uid]sybsystemprocs..sysobjects[uid]10 Rev FK
[suid]master..syslogins[suid]2 FK
[name]master..spt_values[name]2 Rev FK
[uid]sybsystemprocs..sysencryptkeys[uid]2 Rev FK
[uid]sybsystemprocs..sysprotects[grantor]2 Rev FK
[uid]sybsystemprocs..systypes[uid]2 Rev FK
[uid]sybsystemprocs..sysroles[lrid]1 FK1-1
[gid]sybsystemprocs..sysusers[uid]1 FK
[suid]master..sysdatabases[suid]1 Simple Join
[suid]sybsystemprocs..sysalternates[altsuid]1 Simple Join
[uid]sybsystemprocs..sysprotects[uid]1 Rev FK
[uid]sybsystemprocs..sysusers[gid]1 Rev FK
[uid]tempdb..matchinggrantrecords_D6[granteeid]1 Rev FK
[uid]tempdb..matchinggrantrecords_D6[granteeid]1 Rev FK
[name]tempdb..syssrvroles_D8[name]1 Rev FK
[name]tempdb..syssrvroles_D8[name]1 Rev FK

Estimated Index Usage
sysusers.csysusers clustered(suid)134
sysusers.ncsysusers1 unique(name)115
sysusers.ncsysusers2 unique(uid)88

ALIASES USED for sybsystemprocs..sysusers
GNO_ALIASbgssusysusersuu1u2
171152844429

SCHEMA

COLUMN USAGE
suidsp_addalias  sp_addgroup  sp_adduser  sp_aux_encr_verify_downgrade  sp_changedbowner  sp_checknames  sp_dropuser  sp_drv_getcolumnprivileges  sp_drv_gettableprivileges  sp_encryption  sp_helprotect  sp_helpuser  sp_ijdbc_getschemas  sp_jdbc_getschemas  sp_jdbc_getschemas_cts  sp_jdbc_stored_procedures  sp_oledb_getcolumnprivileges  sp_oledb_gettableprivileges 
uidsp_addalias  sp_addgroup  sp_adduser  sp_aux_computeprivs  sp_aux_encr_verify_downgrade  sp_bindexeclass  sp_changedbowner  sp_changegroup  sp_checknames  sp_column_privileges  sp_depends  sp_dropgroup  sp_droptype  sp_dropuser  sp_drv_getcolumnprivileges  sp_drv_gettableprivileges  sp_encryption  sp_helpgroup  sp_helprotect  sp_helpuser  sp_ijdbc_aux_computeprivs  sp_ijdbc_getcolumnprivileges  sp_ijdbc_getprocedurecolumns  sp_ijdbc_stored_procedures  sp_indsuspect  sp_jdbc_computeprivs  sp_jdbc_getsupertypes  sp_jdbc_stored_procedures  sp_modifystats  sp_odbc_stored_procedures  sp_odbc_tables  sp_oledb_getcolumnprivileges  sp_oledb_gettableprivileges  sp_oledb_statistics  sp_oledb_stored_procedures  sp_oledb_tables  sp_oledb_views  sp_replication_path  sp_showcontrolinfo  sp_stored_procedures  sp_tab_suspectptn  sp_table_privileges  sp_tables  sp_unbindexeclass 
gidsp_addgroup  sp_adduser  sp_aux_computeprivs  sp_changegroup  sp_dropgroup  sp_drv_getcolumnprivileges  sp_drv_gettableprivileges  sp_helpgroup  sp_helprotect  sp_helpuser  sp_ijdbc_aux_computeprivs  sp_ijdbc_getcolumnprivileges  sp_ijdbc_stored_procedures  sp_jdbc_computeprivs  sp_jdbc_stored_procedures  sp_modifystats  sp_odbc_stored_procedures  sp_odbc_tables  sp_oledb_getcolumnprivileges  sp_oledb_gettableprivileges  sp_oledb_statistics  sp_oledb_stored_procedures  sp_oledb_tables  sp_oledb_views  sp_stored_procedures  sp_tables 
namesp_addalias  sp_addgroup  sp_adduser  sp_aux_computeprivs  sp_aux_encr_verify_downgrade  sp_bindexeclass  sp_changegroup  sp_checknames  sp_checkreswords  sp_column_privileges  sp_depends  sp_dropgroup  sp_droptype  sp_dropuser  sp_drv_getcolumnprivileges  sp_drv_gettableprivileges  sp_helpgroup  sp_helprotect  sp_helpuser  sp_ijdbc_aux_computeprivs  sp_ijdbc_getcolumnprivileges  sp_ijdbc_getschemas  sp_indsuspect  sp_jdbc_computeprivs  sp_jdbc_getschemas  sp_jdbc_getschemas_cts  sp_jdbc_getsupertypes  sp_oledb_getcolumnprivileges  sp_oledb_gettableprivileges  sp_replication_path  sp_showcontrolinfo  sp_tab_suspectptn  sp_table_privileges  sp_unbindexeclass 
environsp_addgroup 

QUERIES
Joined With Links
sybsystemprocs..sysobjects sybsystemprocs..sp_checknames:319
master..sysmessages sybsystemprocs..sysobjects master..spt_values master..spt_values sybsystemprocs..sp_helpuser:94
sybsystemprocs..syscolumns sybsystemprocs..sysobjects sybsystemprocs..sp_depends:292
sybsystemprocs..sp_droptype:150
master..spt_values sybsystemprocs..sp_checkreswords:275
sybsystemprocs..sp_checkreswords:279
sybsystemprocs..sysindexes sybsystemprocs..sysobjects master..spt_values sybsystemprocs..sp_tab_suspectptn:69
sybsystemprocs..sysdepends sybsystemprocs..sysobjects master..spt_values sybsystemprocs..sp_depends:238
sybsystemprocs..syscolumns master..sysdatabases sybsystemprocs..sysobjects sybsystemprocs..sp_aux_encr_verify_downgrade:294
sybsystemprocs..sysobjects sybsystemprocs..sysprotects sybsystemprocs..sp_tables:325
sybsystemprocs..sp_oledb_statistics:279
sybsystemprocs..sp_oledb_views:285
sybsystemprocs..sp_oledb_tables:343
sybsystemprocs..sp_jdbc_stored_procedures:196
sybsystemprocs..sp_odbc_stored_procedures:186
sybsystemprocs..sp_ijdbc_stored_procedures:179
sybsystemprocs..sp_jdbc_stored_procedures:303
sybsystemprocs..sp_stored_procedures:205
sybsystemprocs..sp_jdbc_stored_procedures:346
sybsystemprocs..sp_oledb_stored_procedures:189
sybsystemprocs..sp_odbc_tables:304
sybsystemprocs..sysindexes sybsystemprocs..sysobjects sybsystemprocs..sp_indsuspect:115
sybsystemprocs..sp_indsuspect:56
sybsystemprocs..sysdepends master..sysmessages master..sysmessages master..sysmessages sybsystemprocs..sysobjects master..spt_values master..spt_values master..spt_values sybsystemprocs..sp_depends:192
sybsystemprocs..sysindexes sybsystemprocs..sysobjects sybsystemprocs..syspartitions master..spt_values sybsystemprocs..sp_tab_suspectptn:128
sybsystemprocs..sp_helpgroup:60
master..sysloginroles master..syssrvroles 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
sybsystemprocs..sysprotects sybsystemprocs..sp_dropuser:456
sybsystemprocs..sp_aux_encr_verify_downgrade:210
sybsystemprocs..sp_modifystats:326
sybsystemprocs..sp_dropuser:449
sybsystemprocs..systypes sybsystemprocs..systypes sybsystemprocs..sp_helpuser:150
sybsystemprocs..sp_jdbc_getsupertypes:34
master..sysloginroles tempdb..posiblegrants_D3 master..syssrvroles 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
sybsystemprocs..sysroles sybsystemprocs..sp_helpgroup:33
tempdb..sysloginroles_D7 tempdb..matchinggrantrecords_D6 tempdb..posiblegrants_D3 tempdb..syssrvroles_D8 sybsystemprocs..sp_oledb_gettableprivileges:155
sybsystemprocs..sp_oledb_gettableprivileges:155
sybsystemprocs..sp_drv_gettableprivileges:161
sybsystemprocs..sp_drv_gettableprivileges:161
sybsystemprocs..sp_oledb_gettableprivileges:155
sybsystemprocs..sp_drv_gettableprivileges:161

COLUMN WRITES detailed
ColumnWritten From
suid    syslogins.suid   sp_adduser.@?   sp_addgroup.@?   sp_gen_login_id.@?  
uid  sysusers.uid   sp_addgroup.@?   sp_adduser.@?  
gid  sysusers.uid   °.gid   sp_addgroup.@?   sp_adduser.@?  
name  sp_adduser.@?   sp_addgroup.@grpname   sp_adduser.@name_in_db   sp_adduser.@loginame  
environ  sp_addgroup.@?  

DATA PROPAGATION detailed
ColumnWritten To
gidsysusers.gid  
namesp_checknames_rset_003.suid sp_checknames_rset_014.name sp_checkreswords_rset_010.Reserved Word Segment Names sp_dropgroup_rset_001.name sp_droptype_rset_001.owner sp_dropuser_rset_002.user_type sp_indsuspect_rset_001.Own.Tab.Ind (Obj_ID, Ind_ID) sp_indsuspect_rset_002.Own.Tab.Ind (Obj_ID, Ind_ID) sp_jdbc_getschemas_rset_001.TABLE_SCHEM sp_jdbc_getsupertypes_rset_001.TYPE_SCHEM
sp_tab_suspectptn_rset_001.Partition type, Own.Tab.Ind (Obj_ID, Ind_ID) sp_tab_suspectptn_rset_002.Partition Type, Own.Tab.Ind.Ptn (Obj_ID, Ind_ID, Ptn_ID)
suidsysalternates.altsuid   sp_checknames_rset_014.suid
uidsysattributes.object_info1   °.char_value   sysattributes.object_info1   °.int_value   °.char_value   sysusers.uid   °.gid   sp_dropdevice_rset_001.device sp_checknames_rset_014.uid sp_displayroles_rset_001.Role Name
sp_displayroles_rset_002.Role Name sp_displayroles_rset_003.Role Name sp_displayroles_rset_004.Role Name sp_dropdevice_rset_001.device sp_forceonline_object_rset_001.Object °.status sp_forceonline_object_rset_002.Object °.status sp_forceonline_page_rset_001.status sp_forceonline_page_rset_002.status
sp_listsuspect_object_rset_001.Object °.Access sp_listsuspect_page_rset_001.Object °.Access sp_makesuspect_obj_rset_001.Obj °.Indid °.LogType °.PageType °.ErrType °.Delay
°.TotalNum sp_makesuspect_obj_rset_002.Obj °.Indid °.LogType °.PageType °.ErrType °.Delay °.TotalNum sp_makesuspect_obj_rset_003.Obj °.Indid
°.LogType °.PageType °.ErrType °.Delay °.TotalNum sp_memlog_rset_001.dumps_per_file 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_ssladmin_rset_001.certificate_path sp_ssladmin_rset_002.Cipher Suite Name °.Preference

DEPENDENCIES
READERS AND WRITERS
read by proc sybsystemprocs..sp_droptype  
read by proc sybsystemprocs..sp_indsuspect  
read by proc sybsystemprocs..sp_modifystats  
read by proc sybsystemprocs..sp_ijdbc_stored_procedures  
read by proc sybsystemprocs..sp_unbindexeclass  
read by proc sybsystemprocs..sp_encryption  
   called by proc sybsystemprocs..sp_downgrade  
read by proc sybsystemprocs..sp_helpjava  
read by proc sybsystemprocs..sp_jdbc_stored_procedures  
read by proc sybsystemprocs..sp_tables  
read by proc sybsystemprocs..sp_addalias  
read by proc sybsystemprocs..sp_stored_procedures  
read by proc sybsystemprocs..sp_oledb_views  
read by proc sybsystemprocs..sp_helprotect  
read_written by proc sybsystemprocs..sp_dropgroup  
read_written by proc sybsystemprocs..sp_changegroup  
read by proc sybsystemprocs..sp_oledb_statistics  
read by proc sybsystemprocs..sp_jdbc_getschemas  
read by proc sybsystemprocs..sp_checknames  
read by proc sybsystemprocs..sp_ijdbc_getschemas  
read_written by proc sybsystemprocs..sp_adduser  
read_written by proc sybsystemprocs..sp_addgroup  
read by proc sybsystemprocs..sp_ijdbc_aux_computeprivs  
read by proc sybsystemprocs..sp_table_privileges  
read by proc sybsystemprocs..sp_helpuser  
read by proc sybsystemprocs..sp_oledb_getcolumnprivileges  
read by proc sybsystemprocs..sp_odbc_stored_procedures  
read by proc sybsystemprocs..sp_showcontrolinfo  
read by proc sybsystemprocs..sp_ijdbc_getcolumnprivileges  
read by proc sybsystemprocs..sp_jdbc_getsupertypes  
read by proc sybsystemprocs..sp_column_privileges  
read by proc sybsystemprocs..sp_aux_encr_verify_downgrade  
read by proc sybsystemprocs..sp_oledb_tables  
read by proc sybsystemprocs..sp_depends  
read by proc sybsystemprocs..sp_drv_gettableprivileges  
   called by proc sybsystemprocs..sp_jdbc_gettableprivileges  
   called by proc sybsystemprocs..sp_odbc_gettableprivileges  
read by proc sybsystemprocs..sp_checkreswords  
read by proc sybsystemprocs..sp_aux_computeprivs  
   called by proc sybsystemprocs..sp_table_privileges  
   called by proc sybsystemprocs..sp_column_privileges  
read by proc sybsystemprocs..sp_helpgroup  
   called by proc sybsystemprocs..sp_helpuser  
read by proc sybsystemprocs..sp_oledb_stored_procedures  
read by proc sybsystemprocs..sp_ijdbc_getprocedurecolumns  
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_jdbc_computeprivs  
read by proc sybsystemprocs..sp_odbc_tables  
read by proc sybsystemprocs..sp_bindexeclass  
read by proc sybsystemprocs..sp_jdbc_getschemas_cts  
read_written by proc sybsystemprocs..sp_changedbowner  
read by proc sybsystemprocs..sp_oledb_gettableprivileges  
read by proc sybsystemprocs..sp_replication_path  
read_written by proc sybsystemprocs..sp_dropuser  
read by proc sybsystemprocs..sp_tab_suspectptn