Re: Deployment App Database SQL Permissions Question
Re: Deployment App Database SQL Permissions Question
- Subject: Re: Deployment App Database SQL Permissions Question
- From: Chuck Hill <email@hidden>
- Date: Thu, 04 Dec 2003 11:34:20 -0800
- Organization: Global Village Consulting, Inc.
Yes, SELECT, INSERT, UPDATE, DELETE should be sufficient. The only
other thing would be PK generation, but I think that MySQL uses the
EO_PK_TABLE so you should be fine.
Chuck
Kieran Kelleher wrote:
For development on my local machine with local MySQL database, I have a
"webobjects" user and password giving webobjects "GRANT ALL ON
mydatabase.*". This ensures my development app and EOModeler have
necessary prvileges for both manipulating data and the schema.
Now when it comes to deployment, I expect my deployed app does not need
ALL privileges to the database.... I guess good security practices would
point in the direction of only giving the deployed app the privileges
that it needs and not more than that.
Would SELECT, INSERT, UPDATE, DELETE privileges be sufficient for the
deployed app? Any input is appreciated...
-K
____________________________________
OS X 10.3.1 / WO 5.2.2 / MySQL 4.0.16
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives:
http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.
--
Chuck Hill email@hidden
Global Village Consulting Inc. http://www.global-village.net
Progress is the mother of all problems.
- G. K. Chesterton
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.