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

1     create table sysprotects(-- 534 Rows, Data: 20 KB, Index: 44 KB
2         id int not null,
3         uid int not null,
4         action smallint not null,
5         protecttype tinyint not null,
6         columns varbinary(133) null,
7         grantor int null,
8         predid int null,
9         status smallint null
10    )
11    
12    
13    create unique clustered index csysprotects on sysprotects(-- 24 KB refcount: 255
14        id, action, grantor, uid, protecttype, predid
15    )
16    
17    alter table sysprotects lock datarows
18    
19    Grant Select on sysprotects to public
20    
JOINS
From ColumnsTo TableTo ColumnsCntCstrStrength
[id]sybsystemprocs..sysobjects[id]36 FK
[uid]sybsystemprocs..sysusers[gid]13 Simple Join
[uid]sybsystemprocs..sysroles[lrid]9 FK
[grantor]sybsystemprocs..sysusers[uid]2 FK
[uid]sybsystemprocs..sysusers[uid]1 FK
[uid]tempdb..posiblegrants_D14[gid]1 Simple Join
[uid]tempdb..posiblegrants_D14[gid]1 Simple Join
[uid]tempdb..posiblegrants_D14[uid]1 Simple Join
[uid]tempdb..posiblegrants_D14[uid]1 Simple Join
[uid]tempdb..posiblegrants_D3[gid]1 Simple Join
[uid]tempdb..posiblegrants_D3[uid]1 Simple Join
[uid]tempdb..posiblegrants_D3[uid]1 Simple Join

Estimated Index Usage
sysprotects.csysprotects unique clustered(id, action, grantor, uid, protecttype, predid)255

ALIASES USED for sybsystemprocs..sysprotects
NO_ALIASpp1protectssysprotects
44332048

SCHEMA

COLUMN USAGE
idsp_aux_computeprivs  sp_changegroup  sp_depends_cols  sp_dropuser  sp_drv_getcolumnprivileges  sp_drv_gettableprivileges  sp_helprotect  sp_ijdbc_aux_computeprivs  sp_ijdbc_getcolumnprivileges  sp_ijdbc_gettableprivileges  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 
uidsp_aux_computeprivs  sp_aux_encr_verify_downgrade  sp_changegroup  sp_dropgroup  sp_dropuser  sp_drv_getcolumnprivileges  sp_drv_gettableprivileges  sp_helprotect  sp_ijdbc_aux_computeprivs  sp_ijdbc_getcolumnprivileges  sp_ijdbc_gettableprivileges  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 
actionsp_aux_computeprivs  sp_aux_encr_verify_downgrade  sp_changegroup  sp_dropuser  sp_drv_getcolumnprivileges  sp_drv_gettableprivileges  sp_helprotect  sp_ijdbc_aux_computeprivs  sp_ijdbc_getcolumnprivileges  sp_ijdbc_gettableprivileges  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 
protecttypesp_aux_computeprivs  sp_changegroup  sp_dropuser  sp_drv_getcolumnprivileges  sp_drv_gettableprivileges  sp_helprotect  sp_ijdbc_aux_computeprivs  sp_ijdbc_getcolumnprivileges  sp_ijdbc_gettableprivileges  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 
columnssp_aux_computeprivs  sp_changegroup  sp_depends_cols  sp_dropuser  sp_drv_getcolumnprivileges  sp_drv_gettableprivileges  sp_helprotect  sp_ijdbc_aux_computeprivs  sp_ijdbc_getcolumnprivileges  sp_jdbc_computeprivs  sp_oledb_getcolumnprivileges  sp_oledb_gettableprivileges 
grantorsp_aux_computeprivs  sp_changegroup  sp_dropuser  sp_drv_getcolumnprivileges  sp_drv_gettableprivileges  sp_helprotect  sp_ijdbc_aux_computeprivs  sp_ijdbc_getcolumnprivileges  sp_ijdbc_gettableprivileges  sp_jdbc_computeprivs  sp_oledb_getcolumnprivileges  sp_oledb_gettableprivileges 
predidsp_changegroup  sp_drv_getcolumnprivileges  sp_drv_gettableprivileges  sp_helprotect  sp_oledb_getcolumnprivileges  sp_oledb_gettableprivileges 

QUERIES
Joined With Links
sybsystemprocs..sysobjects sybsystemprocs..sp_ijdbc_gettableprivileges:76
sybsystemprocs..sp_ijdbc_gettableprivileges:86
sybsystemprocs..sp_ijdbc_gettableprivileges:163
sybsystemprocs..sp_ijdbc_gettableprivileges:130
sybsystemprocs..sp_ijdbc_getcolumnprivileges:323
sybsystemprocs..sp_ijdbc_gettableprivileges:53
sybsystemprocs..sp_ijdbc_getcolumnprivileges:222
sybsystemprocs..sp_ijdbc_getcolumnprivileges:255
sybsystemprocs..sp_ijdbc_getcolumnprivileges:288
sybsystemprocs..sp_ijdbc_getcolumnprivileges:188
sybsystemprocs..sp_ijdbc_gettableprivileges:154
sybsystemprocs..sp_ijdbc_gettableprivileges:143
sybsystemprocs..sp_ijdbc_gettableprivileges:98
sybsystemprocs..sp_ijdbc_gettableprivileges:63
sybsystemprocs..sp_ijdbc_gettableprivileges:120
sybsystemprocs..sp_ijdbc_gettableprivileges:108
sybsystemprocs..sysobjects sybsystemprocs..sysusers 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..sysobjects sybsystemprocs..sysroles master..syssrvroles 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
sybsystemprocs..sysusers sybsystemprocs..sp_dropuser:456
sybsystemprocs..sp_aux_encr_verify_downgrade:210
sybsystemprocs..sp_modifystats:326
sybsystemprocs..sp_dropuser:449
sybsystemprocs..sysroles master..syssrvroles sybsystemprocs..sp_modifystats:274

COLUMN WRITES detailed
ColumnWritten From
columns  sysprotects.columns   syb_aux_privnots.@?   syb_aux_privsand.@?   syb_aux_expandbitmap.@?   sp_changegroup.@?   syb_aux_privunion.@?   syb_aux_privexor.@?  

DATA PROPAGATION detailed
ColumnWritten To
columnssysprotects.columns  

DEPENDENCIES
READERS AND WRITERS
read by proc sybsystemprocs..sp_helprotect  
read by proc sybsystemprocs..sp_ijdbc_aux_computeprivs  
read by proc sybsystemprocs..sp_stored_procedures  
read by proc sybsystemprocs..sp_oledb_tables  
read by proc sybsystemprocs..sp_modifystats  
read by proc sybsystemprocs..sp_depends_cols  
   called by proc sybsystemprocs..sp_depends  
read by proc sybsystemprocs..sp_ijdbc_getcolumnprivileges  
written by proc sybsystemprocs..sp_dropgroup  
read by proc sybsystemprocs..sp_oledb_getcolumnprivileges  
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_ijdbc_gettableprivileges  
read by proc sybsystemprocs..sp_oledb_views  
read by proc sybsystemprocs..sp_ijdbc_stored_procedures  
read_written by proc sybsystemprocs..sp_changegroup  
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_oledb_gettableprivileges  
read by proc sybsystemprocs..sp_jdbc_computeprivs  
read by proc sybsystemprocs..sp_oledb_statistics  
read_written by proc sybsystemprocs..sp_dropuser  
read by proc sybsystemprocs..sp_odbc_tables  
read by proc sybsystemprocs..sp_jdbc_stored_procedures  
read by proc sybsystemprocs..sp_odbc_stored_procedures  
read by proc sybsystemprocs..sp_aux_computeprivs  
   called by proc sybsystemprocs..sp_column_privileges  
   called by proc sybsystemprocs..sp_table_privileges  
read by proc sybsystemprocs..sp_tables  
read by proc sybsystemprocs..sp_oledb_stored_procedures  
read by proc sybsystemprocs..sp_aux_encr_verify_downgrade