Deployment App Database SQL Permissions Question
Deployment App Database SQL Permissions Question
- Subject: Deployment App Database SQL Permissions Question
- From: Kieran Kelleher <email@hidden>
- Date: Thu, 4 Dec 2003 07:03:39 -0500
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.