No team coding in Toad, I use the command line for GIT
Here is the spool, i turned spool on, then hit f9
-- Session: MARC_B@MARCDB
-- Timestamp: 15:02:02.525
Select object_name, object_type, status, owner
from SYS.ALL_OBJECTS
where owner = 'MARC_B'
and object_type = 'PROCEDURE'
and object_name = 'XXX'
order by object_name;
-- Elapsed Time: 0 seconds
-- Rows fetched: 1
-- Session: MARC_B@MARCDB
-- Timestamp: 15:02:02.525
Select s.*
FROM SYS.ALL_SYNONYMS s
WHERE ((s.OWNER = 'MARC_B') OR ((s.TABLE_OWNER = 'MARC_B') or (s.table_owner is null) and s.OWNER = 'PUBLIC'))
and S.TABLE_NAME = 'XXX'
and s.db_link is null
order by s.owner, s.synonym_name;
-- Elapsed Time: 0.031 seconds
-- Rows fetched: 0
-- Session: MARC_B@MARCDB
-- Timestamp: 15:02:02.556
Select *
from sys.user_obj_audit_opts
where (SUBSTRB (alt, 1, 1) in ('-', 'A', 'S')) and
((alt <> '-/-') or (aud <> '-/-') or (com <> '-/-') or
(del <> '-/-') or (gra <> '-/-') or (ind <> '-/-') or
(ins <> '-/-') or (loc <> '-/-') or (ren <> '-/-') or
(sel <> '-/-') or (upd <> '-/-') or
(exe <> '-/-') or (rea <> '-/-') or (wri <> '-/-') or (fbk <> '-/-'))
and object_type in ('PROCEDURE')
and OBJECT_NAME = 'XXX';
-- Elapsed Time: 0 seconds
-- Rows fetched: 0
-- Session: MARC_B@MARCDB
-- Timestamp: 15:02:02.556
Select
line,
name, text
from SYS.USER_SOURCE
where 1=1
and type = 'PROCEDURE'
and name in (
'XXX'
)
order by name, line;
-- Elapsed Time: 0 seconds
-- Rows fetched: 10
-- Session: MARC_B@MARCDB
-- Timestamp: 15:02:02.556
Select t.grantee, t.owner, t.table_name, t.grantor, t.privilege, t.grantable,
t.HIERARCHY,
o.OBJECT_TYPE, 'NO' as COMMON
from SYS.USER_TAB_PRIVS t, SYS.USER_OBJECTS o
where 1=1
and t.TABLE_NAME = o.OBJECT_NAME
and o.object_type in ('PROCEDURE')
and t.owner = 'MARC_B'
and TABLE_NAME = 'XXX'
ORDER BY 1, 2, 3, 5;
-- Elapsed Time: 0 seconds
-- Rows fetched: 0
-- Session: MARC_B@MARCDB
-- Timestamp: 15:02:02.556
Select object_name, object_type, status, owner
from SYS.ALL_OBJECTS
where owner = 'MARC_B'
and object_type = 'PROCEDURE'
and object_name = 'XXX'
order by object_name;
-- Elapsed Time: 0 seconds
-- Rows fetched: 1
-- Session: MARC_B@MARCDB
-- Timestamp: 15:02:02.556
Select s.*
FROM SYS.ALL_SYNONYMS s
WHERE ((s.OWNER = 'MARC_B') OR ((s.TABLE_OWNER = 'MARC_B') or (s.table_owner is null) and s.OWNER = 'PUBLIC'))
and S.TABLE_NAME = 'XXX'
and s.db_link is null
order by s.owner, s.synonym_name;
-- Elapsed Time: 0.031 seconds
-- Rows fetched: 0
-- Session: MARC_B@MARCDB
-- Timestamp: 15:02:02.588
Select *
from sys.user_obj_audit_opts
where (SUBSTRB (alt, 1, 1) in ('-', 'A', 'S')) and
((alt <> '-/-') or (aud <> '-/-') or (com <> '-/-') or
(del <> '-/-') or (gra <> '-/-') or (ind <> '-/-') or
(ins <> '-/-') or (loc <> '-/-') or (ren <> '-/-') or
(sel <> '-/-') or (upd <> '-/-') or
(exe <> '-/-') or (rea <> '-/-') or (wri <> '-/-') or (fbk <> '-/-'))
and object_type in ('PROCEDURE')
and OBJECT_NAME = 'XXX';
-- Elapsed Time: 0 seconds
-- Rows fetched: 0
-- Session: MARC_B@MARCDB
-- Timestamp: 15:02:02.588
Select
line,
name, text
from SYS.USER_SOURCE
where 1=1
and type = 'PROCEDURE'
and name in (
'XXX'
)
order by name, line;
-- Elapsed Time: 0 seconds
-- Rows fetched: 10
-- Session: MARC_B@MARCDB
-- Timestamp: 15:02:02.588
Select t.grantee, t.owner, t.table_name, t.grantor, t.privilege, t.grantable,
t.HIERARCHY,
o.OBJECT_TYPE, 'NO' as COMMON
from SYS.USER_TAB_PRIVS t, SYS.USER_OBJECTS o
where 1=1
and t.TABLE_NAME = o.OBJECT_NAME
and o.object_type in ('PROCEDURE')
and