I don't know if this specific question has been asked - but searches haven't given me a close enough answer so hopefully this is a little new.
Separate from security theories and considerations of "good practice", what, if any, benefits accrue from using multiple users when accessing a Firebird database?
If that's too general a question, here's my specific need. I have a database that has at least three simultaneous connections via PHP. I have two long-running PHP daemons (yes I know PHP isn't intended for such but it works and allows me to keep a consistent code base). These listen for external events and update the database accordingly. Part of their updates do involve reads as well. Then the main application is PHP via Nginx/php-fpm.
I cache the database connection via the http session for the application - the daemons just keep the connection open as an application global.
At this time, everything is just using the SYSDBA user. I'm not certain, but I think from time to time there is a visibility issue. I'll update information via the web application, and confirm it in both the web application and FlameRobin - but my daemons don't seem to see the changes. Stopping/starting the daemons appears to correct the problem. As I say - this is totally unconfirmed and I'd need more testing to narrow this down.
Again - separate from security considerations - are there any reasons/benefits to creating and using individual users for each of these connections? Security-wise, I'm the only user and the server isn't internet exposed so I'm not terribly worried at the moment.
--
Daniel
__._,_.___
Posted by: "Daniel Miller" <dmiller@amfes.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1) |
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu. Try FAQ and other links from the left-side menu there.
Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu. Try FAQ and other links from the left-side menu there.
Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
.
__,_._,___
No comments:
Post a Comment