I was wondering if there was any way to make it so an admin can view every record in the database, but a user can only view records pertaining to them. Such as a student has their own log in, and they can only view their own grade which is updated via admin.

Thanks!

Yep. Look at the settings in the default.cfg file. I also use "JPDeni's Configurator" to setup my config files since it takes a lot of the guess work out of doing it.

Here is the main link:

http://www.jpdeni.com/dbman/index.html

Thanks for the reply.

I have used that and I'm not sure exactly where it says I can configure such things. Is there anyway you can point it out?

Thanks!

See pics below...

Good Luck!

Hope you're not connecting via dial-up

conf1 = 131k
conf2 = 70k
conf3 = 450k

Within JPDeni's tutorial she also has a great chart for setting permissions.

I think what you would want to use to only allow the user to view, modify and delete their own records would be:

$auth_no_authentication = 0;
$auth_allow_default = 0;

# Default permissions used if there is no authentication, or for a default user. (View, Add, Delete, Modify, Admin), 1 = enable, 0 = disable.
@auth_default_permissions = (0,0,0,0,0);

$auth_signup = 1; ## turned off to not allow others to enter new records
@auth_signup_permissions = (1,1,0,1,0);
$auth_modify_own = 1;
$auth_view_own = 1;
$auth_user_field = 19; ### change this to the field number for your Userid field

If you only want them to view and not modify or delete this will work:

@auth_signup_permissions = (1,0,0,0,0);

Hope this helps

Unoffical DBMan FAQ
http://redundantcartridge.com/dbman/