Page 1 of 1
Number of database webusers?
Posted: Tue Jun 03, 2003 8:35 am
by nielsene
In some conversations off this forum with other web-scripters/programmers I found that most seem to use a single "webuser" login per server for connecting to their database(s). Even if they have multiple, distinct applications/databases. In some cases this was because that's all theiir web-hoster allowed, but in many cases they just never considered using more than one and passing some of the user authorization duties off to the DBMS.
So how many database users do you use?
Posted: Tue Jun 03, 2003 9:39 am
by twigletmac
I tend to setup users to do specific things, so that we have users for database administration which can SELECT, INSERT, UPDATE and DELETE on specified databases and/or tables; users which are used to access tables for data retrieval purposes only (can't do anything but SELECT) as well as a couple of database admin users with full MySQL privileges.
Mac
Posted: Tue Jun 03, 2003 9:47 am
by nielsene
I set things up in a similar manner, most applications get at least three websuers: tool_unauth_user, tool_auth_user, and tool_admin_user. The first is for non-logged in page views. The second for logged-in but not admin useres. I'll normally create two usergroups, if the database supports it, tool_all that has the three users in it and tool_trusted that has both classes of logged in users. (In all the above cases the "tool" gets replaced with an identifier for the application)
Typically none of these are "database super users" -- they can't create new databases or new users. I normally restrict such things to the command-line database users.