Source Control for Oracle

Required privileges

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> or ALTER ANY <OBJECT TYPE> to alter objects (eg ALTER ANY PROCEDURE)
  • CREATE <OBJECT TYPE> or CREATE ANY <OBJECT TYPE> to create objects (eg ALTER INDEX)
  • DROP <OBJECT TYPE> or DROP ANY <OBJECT TYPE> to drop objects (eg DROP TABLE)

Didn't find what you were looking for?