Re: A few newbie questions

[Phillip Ward]

I would strongly recommend you do not create database level accounts for your Users.
Instead, create an account for the Application to use and do all the database access with that. Manage "Users" as regular data, in regular tables.

Why? Consider the most basic of User issues - resetting a forgotten password.
They cannot get into the database to reset their password because they've forgotten their database password!

If your Application takes care of all the database-level stuff, then they can reset their password (managed in your tables, not system ones) any time they like, thereby eliminating a huge amount of calls / tickets / aggravation for you to deal with.

Regards, Phill W.