1;M;Tables/Views within Database;Select distinct creator from SYS.SYSCATALOG order by 1;Owner;1500;
2;M;Tables (only) within Database;Select distinct creator from SYS.SYSCATALOG WHERE tabletype='TABLE' order by 1;Owner;1500;
3;M;Views within Database;Select distinct creator from SYS.SYSCATALOG WHERE tabletype='VIEW' order by 1;Owner;1500;
4;M;Indexes within Database;Select distinct owner from all_indexes;Owner;1500;
5;M;Triggers within Database;Select distinct owner from SYS.SYSTRIGGERS order by 1;Owner;1500;
8;M;Procedures within Database;select distinct user_name From SYS.SYSPROCEDURE a, SYS.sysuserperm b where a.creator=b.user_id order by 1;Owner;1500;
9;M8;Files within Database;Select file_id, dbspace_name, file_name from SYS.SYSFILE;File Id;800;Space Name;1000;File Name;2000;
10;M;Tables/Views within Owner;Select tname, tabletype, remarks from SYS.SYSCATALOG where creator=? order by 1;Table;2325;Type;615;Desc;495;
11;M;Tables (only) within Owner;Select tname, remarks from SYS.SYSCATALOG where creator=? AND tabletype='TABLE' order by 1;Table;2000;Desc;2500;
12;M;Views within Owner;Select tname, remarks from SYS.SYSCATALOG where creator=? AND tabletype='VIEW' order by 1;View;3000;Desc;2500;
13;M;Indexes within Owner;Select index_name from all_indexes where owner = ? order by 1;Index;3000;
14;M;Triggers within Owner;Select trigname from SYS.SYSTRIGGERS WHERE owner=?;Trigger;2000;
15;M;Tablespaces within Database;Select TABLESPACE_NAME, STATUS from SYS.USER_TABLESPACES;Tablespace;2000;Status;1000;
16;U;Users/Groups within Database;Select name, user_group from SYS.SYSUSERLIST order by 1;User Name;960;Group?;630;
18;M;Procedures within Owner;select a.proc_name, a.remarks From SYS.SYSPROCEDURE a, SYS.SYSUSERPERM b where a.creator=b.user_id and b.user_name=? order by 1;Procedure;2895;Desc;495;
19;M;Tables within File;Select (select user_name from SYS.sysuserperm where user_id=creator), table_name, count from SYS.SYSTABLE WHERE file_id =0 and table_type <> 'VIEW' order by count desc;Owner;1500;Table Name;2000;Rows;800;
20;C;Column list for;select column_name, (select domain_name from SYS.SYSDOMAIN where domain_id=c.domain_id),width,scale,nulls,t.remarks,column_id,'' from SYS.SYSCOLUMN c join SYS.SYSTABLE t join SYS.SYSUSERPERM u where user_name=? and table_name=? order by column_id;Name;1155;Type;540;Length;650;Scale;500;Nulls;500;Desc;495;Default;615;
21;M;Access list for;Select grantee, selectauth, updateauth, insertauth, deleteauth, referenceauth, alterauth from SYS.SYSTABAUTH WHERE screator=? AND stname=? order by grantee;Userid;1500;Select;600;Upd;600;Insert;600;Del;600;Ref;600;Alter;600;
22;S;Full details of;select b.* from sysusers a, systable b where a.uid = b.creator and a.name = ? and b.table_name = ?;Column;1500;Value;3000;
23;M;Dependent Tables of;Select foreign_creator, foreign_tname, role, columns from SYS.SYSFOREIGNKEYS WHERE primary_creator=? and primary_tname=?;FK Creator;1200;FK Table;1500;Role;1200;Columns;3000;
24;M;Tables Referenced by;Select primary_creator, primary_tname, role, columns from SYS.SYSFOREIGNKEYS WHERE foreign_creator=? and foreign_tname=?;PK Creator;1200;PK Table;1500;Role;1200;Columns;3000;
25;A;Access list for;Select distinct screator, stname,selectauth, updateauth, insertauth, deleteauth, alterauth, referenceauth from SYS.SYSTABAUTH WHERE grantee = ? order by 1,2;Creator;615;Table;525;Select;585;Update;630;Insert;510;Delete;600;Alter;405;References;990;
26;M;Triggers on table;Select owner, trigname, event, trigtime from SYS.SYSTRIGGERS WHERE owner=? AND tname=?;Owner;1500;Name;1800;Event;1200;Time;1000;
27;M;Full details of trigger;select owner,tname,event,trigtime from systriggers where owner=? and trigname=?;Owner;1200;Table;1800;Event;1200;Time;1000;
29;V;Definition of View;Select viewtext from SYS.SYSVIEWS WHERE vcreator= ? and viewname =?;View Definition;3000;
30;W;Definition of View;Select viewtext from SYS.SYSVIEWS WHERE vcreator= ? and viewname =?;View Definition;5895;
31;X;Check Constraints on;select "check" from SYS.syscatalog where creator=? and tname=? and "check" is not null;Text;5280;
32;M;Indexes on ;select(select user_name from SYS.SYSUSERPERM where user_id=SYSINDEX.creator), index_name, if "unique"='N' then 'Non-unique' else if "unique"='U' then 'UNIQUE constraint' else 'Unique' endif endif, (select list(string(column_name, if "order"='A' then ' ASC' else ' DESC' endif)) from SYS.SYSIXCOL join SYS.SYSCOLUMN where index_id=SYSINDEX.index_id and SYSIXCOL.table_id=SYSINDEX.table_id) from SYS.SYSTABLE join SYS.SYSINDEX where SYSINDEX.creator=(select user_id from SYS.SYSUSERPERM where user_name=? ) and table_name=?;Owner;1500;Index Name;1800;Type;1000;Columns;3000;
33;T;Full details of trigger;select trigdefn from SYS.systriggers where owner=? and trigname=?;Text;5280;
34;D;Contents of;x;Name;1500;
35;M;Trigger on table;Select owner,TRIGGER_NAME,TRIGGERING_EVENT from SYS.ALL_TRIGGERS WHERE TABLE_OWNER=? AND TABLE_NAME=?;Owner;1200;Trigger Name;2500;Event;1500;
36;M;Privileges on;Select distinct GRANTEE, PRIVILEGE, GRANTABLE, GRANTOR from SYS.ALL_TAB_PRIVS WHERE TABLE_SCHEMA=? AND TABLE_NAME=?;User;1200;Privilege;1500;Grantable;800;Granted by;1000;
37;M;All privileges on;Select distinct GRANTEE, PRIVILEGE, GRANTABLE, GRANTOR from SYS.DBA_TAB_PRIVS WHERE owner=? AND TABLE_NAME=?;User;1200;Privilege;1500;Grantable;800;Granted by;1000;
39;M;Column Sizing for;Select COLUMN_NAME, NUM_DISTINCT, LOW_VALUE, HIGH_VALUE, DENSITY from SYS.ALL_TAB_COLUMNS WHERE owner = ? and TABle_name=? order by column_id;Column;2000;Num Distinct;1000;Low Value;1000;High Value;1200;Density;800;
40;M;Tables within Tablespace;Select OWNER,TABLE_NAME,BLOCKS,NUM_ROWS,INITIAL_EXTENT,NEXT_EXTENT from SYS.ALL_TABLES WHERE TABLESPACE_NAME=? ORDER BY BLOCKS desc;Tab Owner;1500;Tab Name;2500;Blocks;800;Rows;800;First Extent;1000;Next Extent;1000;
41;S;Details of Tablespace;Select * from SYS.USER_TABLESPACES where tablespace_name=?;Column;2000;Value;3000;
42;M;Primary Index on;Select a.owner, a.CONSTRAINT_NAME, b.COLUMN_NAME, b.column_position, a.STATUS from SYS.ALL_CONSTRAINTS A, SYS.ALL_IND_COLUMNS B WHERE A.OWNER=B.INDEX_OWNER AND A.CONSTRAINT_NAME = B.INDEX_NAME AND a.OWNER=? AND a.TABLE_NAME=? AND CONSTRAINT_TYPE='P' order by COLUMN_position;Index Owner;1500;Index Name;1500;Column Name;1500;Seq;500;Status;800;
43;M;Foreign Keys for;Select b.Table_owner, b.table_name, a.delete_rule, b.COLUMN_NAME, b.column_position, a.R_CONSTRAINT_NAME, a.STATUS from SYS.ALL_CONSTRAINTS A, SYS.ALL_IND_COLUMNS B WHERE A.R_OWNER = B.INDEX_OWNER AND A.R_CONSTRAINT_NAME=B.INDEX_NAME AND a.OWNER=? AND a.TABLE_NAME=? AND CONSTRAINT_TYPE='R' order by 1,2,5;Table Owner;1500;Table Name;1500;Delete Rule;1200;Col Name;1500;Seq;500;Constraint;1200;Status;1000;
44;M;Unique Indexes on;Select a.owner, a.CONSTRAINT_NAME, b.COLUMN_NAME, b.column_position, a.STATUS from SYS.ALL_CONSTRAINTS A, SYS.ALL_IND_COLUMNS B WHERE A.OWNER=B.INDEX_OWNER AND A.CONSTRAINT_NAME = B.INDEX_NAME AND a.OWNER=? AND a.TABLE_NAME=? AND CONSTRAINT_TYPE='U' order by COLUMN_position;Index Owner;1500;Index Name;1500;Column Name;1500;Seq;500;Status;800;
46;M;Users in Group;Select member_name from SYS.SYSGROUPS WHERE group_name =? order by 1;User Name;1500;
47;M;System privileges for;Select PRIVILEGE,ADMIN_OPTION from SYS.DBA_SYS_PRIVS WHERE GRANTEE=?;Privilege;2500;Admin Option;1500;
48;M;Groups for User;Select group_name from SYS.SYSGROUPS WHERE member_name =? order by 1;Group Name;1080;
49;B;Access list for;Select distinct screator, stname,grantor,selectauth, updateauth, insertauth, deleteauth, alterauth, referenceauth from SYS.SYSTABAUTH WHERE grantee = ? order by 1,2;Creator;615;Table;1335;Grantor;630;Select;585;Update;630;Insert;510;Delete;600;Alter;405;References;990;
50;S;Details of Procedure;select b.user_name, a.proc_name, a.proc_id,a.proc_defn,a.remarks, a.replicate From SYS.SYSPROCEDURE a, SYS.SYSUSERPERM b where a.creator=b.user_id and b.user_name=? and a.proc_name=?;Column;960;Value;7590;
51;X;Text of Procedure;select proc_defn From SYS.SYSPROCEDURE a, SYS.sysuserperm b where a.creator=b.user_id and user_name = ? and proc_name=?;Procedure Text;12000;
52;M;Parameters for Procedure;select parmname, parmtype, parmmode, parmdomain, length, remarks From SYS.SYSPROCPARMS WHERE creator=? AND procname=?;Parm;885;Type;465;Mode;525;Domain;645;Length;645;Desc;495;
53;M;Authorities for Procedure;Select grantee from SYS.SYSPROCAUTH WHERE creator=? and procname=?;Grantee;1500;
54;M;Authorities for Procedure;Select creator,procname from SYS.SYSPROCAUTH WHERE grantee=?;Owner;600;Procedure Name;1440;
55;M;Authorities for ;select resourceauth, dbaauth, scheduleauth From SYS.SYSUSERAUTH Where name = ?;Resource;1000;DBA;1000;Schedule;1000;
56;Q;View as Query;Select viewtext from SYS.SYSVIEWS WHERE vcreator= ? and viewname =?;View Definition;5895;
