Opened 16 years ago

Closed 16 years ago

#4692 closed (fixed)

Document required database user permissions

Reported by: Carl Karsten <carl@…> Owned by: nobody
Component: Documentation Version: dev
Severity: Keywords: sql sprintsept14
Cc: Triage Stage: Ready for checkin
Has patch: yes Needs documentation: no
Needs tests: no Patch needs improvement: no
Easy pickings: no UI/UX: no

Description (last modified by Malcolm Tredinnick)

On the db setup page

There should be some specs on what rights django needs.

easies way to define it is with the command:

grant all on djangosite.* to djangouser identified by 'abc' with grant option;

For the various dbs.

Only A) someone should figure out what rights are really needed,
and B) maybe come up with 2 users, one for creating tables with syncdb.

I can see the attitude of "if you are going to run a server you should know" but this doesn't do much good for people who just want to try it out, and i like the DBA attitude of 'you prove to me why you need it and I'll give it to you."

Attachments (1)

4692.diff (2.5 KB) - added by James Bennett 16 years ago.
Patch explaining necessary privileges

Download all attachments as: .zip

Change History (6)

comment:1 Changed 16 years ago by Malcolm Tredinnick

Description: modified (diff)
Summary: sql rightsDocument required database user permissions

comment:2 Changed 16 years ago by Simon G. <dev@…>

Triage Stage: UnreviewedAccepted

#4757 was marked as a dupe.

Changed 16 years ago by James Bennett

Attachment: 4692.diff added

Patch explaining necessary privileges

comment:3 Changed 16 years ago by James Bennett

Triage Stage: AcceptedReady for checkin

Attached a patch to install.txt explaining minimum necessary privileges for setting up a database for Django's use, and to testing.txt reminding users that creating a test database requires CREATE DATABASE.

comment:4 Changed 16 years ago by James Bennett

Has patch: set
Keywords: sprintsept14 added

comment:5 Changed 16 years ago by Adrian Holovaty

Resolution: fixed
Status: newclosed

(In [6260]) Fixed #4692 -- Documented required database privileges. Thanks, ubernostrum

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