Required privileges
Published 23 March 2022
If you're not the owner of the schemas you want to link to source control, you need:
SELECT
privileges for non-PL/SQL objects (eg tables, views, synonyms)EXECUTE
privileges for PL/SQL objects (eg procedures, functions, packages)
If you don't have sufficient privileges for an object, it isn't displayed in the Get latest or Check in tabs.
Privileges required for dedicated schemas
If you have a dedicated copy of a schema, you may also need these privileges to get changes:
ALTER <OBJECT TYPE>
orALTER ANY <OBJECT TYPE>
to alter objects (egALTER ANY PROCEDURE)
CREATE <OBJECT TYPE>
orCREATE ANY <OBJECT TYPE>
to create objects (egALTER INDEX)
DROP <OBJECT TYPE>
orDROP ANY <OBJECT TYPE>
to drop objects (egDROP TABLE)