SybaseIQ中那个系统表是用来存储每个用户具有操作权限的表

[sdhzczzz]

SybaseIQ中那个系统表是用来存储每个用户具有操作权限的表的，比如user1用户，创建了4个表，并且dba把region表格的操作权限也给了User1，那个系统表格可以列出user1具有操作权限的4个表和region表

[iihero]

看看下边的这个SQL是否有用？ ALTER VIEW "SYS"."SYSTABAUTH"( grantor, grantee,screator,stname,tcreator,ttname, selectauth,insertauth,deleteauth, updateauth,updatecols,alterauth,referenceauth ) as select u1.user_name,u2.user_name,u3.user_name,tab1.table_name, u4.user_name,tab2.table_name,tp.selectauth,tp.insertauth, tp.deleteauth,tp.updateauth,tp.updatecols,tp.alterauth, tp.referenceauth from SYS.ISYSTABLEPERM as tp join SYS.ISYSUSER as u1 on u1.user_id = tp.grantor join SYS.ISYSUSER as u2 on u2.user_id = tp.grantee join SYS.ISYSTAB as tab1 on tab1.table_id = tp.stable_id join SYS.ISYSUSER as u3 on u3.user_id = tab1.creator join SYS.ISYSTAB as tab2 on tab2.table_id = tp.stable_id join SYS.ISYSUSER as u4 on u4.user_id = tab2.creator