Gossamer Forum: Products: DBMan SQL: Discussion: Re: [TheStone] Just bought ... my questions and reflections (kjellkk)

In Reply To:

- How can I easily configure a completely separate database as it says in the overview? Ie I want one of my users to have total control (admin access)

Just set the 'Admin' permision to users, so they will have full access to user tables ( by using Admin - Tables - Users function ). I'm not sure I understood this reply. From what I can see I set admin permission for a user it means he/she can modify his/her login information. No access to the full admin interface. My question was about giving a user an instance of DBMAN-SQL to work on a completely different MySQL database. Must admit that I don't really understand the users configuration in DBMAN-SQL. I thought setting permissions was done per table, but now it seems that any settings I set for a user is valid for all tables. Ie if a user has full viewing access to any table he/she can also view any record in the users database - where the passwords show in cleartext! There must be something wrong?

In Reply To:

- any who have setup validation of new user sign-ups?

Quote:

You can change the command below around line #320 within Home.pm:

# You can change the status as you desire. it can be 'Not Validated'
$user->{Status} = 'Registered';

To:

# You can change the status as you desire. it can be 'Not Validated'
$user->{Status} = 'Not Validated';

From now on, the signed-up users cannot access the system unless they're validated.

Well - but does that activate any way of the admin getting e-mail messages when someone signs up etc? I was thinking about something like require_signup_admin_validation from Gossamer Forum. How would one proceed to configure DBMAN SQL to use a table from another SQL database for users? Say my forum is running in a separate database but I want to use the user table from that to manage my DBMan SQL users. thanks -kjell
---
Kjell Knudsen
http://www.icbl.org

Subject	Author	Views	Date
Just bought ... my questions and reflections	kjellkk	4033	Mar 18, 2003, 9:11 AM

Re: [kjellkk] Just bought ... my questions and reflections	604	3848	Mar 18, 2003, 2:33 PM

Re: [TheStone] Just bought ... my questions and reflections	kjellkk	3809	Mar 19, 2003, 3:57 AM

Re: [kjellkk] Just bought ... my questions and reflections	604	3800	Mar 19, 2003, 10:12 AM

Re: [TheStone] Just bought ... my questions and reflections	kjellkk	3784	Mar 20, 2003, 2:22 AM

Re: [TheStone] Just bought ... my questions and reflections	Karen	3691	May 15, 2003, 8:55 AM