Opened 4 years ago

Closed 3 years ago

Last modified 3 years ago

#20005 closed Bug (fixed)

Document that Oracle databases need execute permission on SYS.DBMS_LOB.

Reported by: jafula Owned by: nobody
Component: Documentation Version: 1.5
Severity: Normal Keywords: oracle database permission dbms_lob
Cc: Triage Stage: Accepted
Has patch: yes Needs documentation: no
Needs tests: no Patch needs improvement: no
Easy pickings: no UI/UX: no

Description

The oracle database back-end uses SYS.DBMS_LOB. Could the documentation about Oracle on the database page be updated to include this?

You can find the reference to dbms_lob in django\db\backends\oracle\base.py

The permission required is:

grant execute on SYS.DBMS_LOB to SCHEMA_NAME;

Attachments (1)

20005.diff (574 bytes) - added by Tim Graham 3 years ago.

Download all attachments as: .zip

Change History (6)

comment:1 Changed 4 years ago by Jacob

Needs documentation: unset
Needs tests: unset
Patch needs improvement: unset
Triage Stage: UnreviewedAccepted
Type: UncategorizedBug

Changed 3 years ago by Tim Graham

Attachment: 20005.diff added

comment:2 Changed 3 years ago by Tim Graham

Has patch: set

Could someone familiar with Oracle review the attached patch?

comment:3 Changed 3 years ago by Tim Graham <timograham@…>

Resolution: fixed
Status: newclosed

In a86ecc80a2665378c336aec16274fb1539066d9b:

Fixed #20005 -- Documented that Oracle databases need execute permission on SYS.DBMS_LOB.

Thanks jafula for the suggestion.

comment:4 Changed 3 years ago by Tim Graham <timograham@…>

In 9d3a66aa9fd33f68fc22fc1d86b7aaf382018f57:

[1.5.x] Fixed #20005 -- Documented that Oracle databases need execute permission on SYS.DBMS_LOB.

Thanks jafula for the suggestion.

Backport of a86ecc80a2 from master

comment:5 Changed 3 years ago by Tim Graham <timograham@…>

In 7b8037f3aa880397d16c7a11647d53f92b7cec67:

[1.6.x] Fixed #20005 -- Documented that Oracle databases need execute permission on SYS.DBMS_LOB.

Thanks jafula for the suggestion.

Backport of a86ecc80a2 from master

Note: See TracTickets for help on using tickets.
Back to Top