Geeklog Forums

I set up a Username for my employee and granted him permission as a user admin.

He started adding users ( almost 1000 ).

I then started getting e-mails from these users that they could not access the site.

I then determined that every one of these users were in the database but were not in any Security Groups ( All Users and Logged In Users) had been the default that was set for each user I had perviously added.

My questions is two in 2 parts.

1. How do I allow my employee who I do not want to have full root permission add users without this challenge.

2. How do I change what has happened without in the database. I know how to do it user-by-user but that would take hours....

Please let me know.

Thanks

Eric.

To answer your first question, you need to assign a user to
the User Admin and Group Admin security groups. This will
allow them to create new users and assign groups.

The second question is more complicated. Your best bet is
running some type of sql query to update the
gl_group_assignments table. Be sure to back-up your data before running any query.

You first need to determine the group numbers of the
All-Users and Logged-in Users (and any other Groups you
want auto-assigned). Then you need to determine the user
ids (UID form gl_users table) of the impacted users. Once you
have that you can run a query similar to the following for each
user (note it's one query for each group assignment):

SAMPLE QUERY to ASSIGN All Users Group (12 is the UID):
=======================================
INSERT INTO `gl_group_assignments` ( `ug_main_grp_id` ,
`ug_uid` , `ug_grp_id` )
VALUES (
'2', '12', NULL
);

SAMPLE QUERY to Logged-in Users Group (12 is the UID):
=======================================
INSERT INTO `gl_group_assignments` ( `ug_main_grp_id` ,
`ug_uid` , `ug_grp_id` )
VALUES (
'13', '12', NULL
);

Of course, you could also build a php script to create the sql
for you. Either way, there's effort involved.

---

In a world without walls and fences, who needs Windows and Gates?