Hi all,

I have a user in my DB, I want that user to be able to
create users/delete users.

What permissions do I need to set for this to be allowed?

I've set "Administer" on the user's permissions, but this
hasn't made any difference.

Is it the case that ONLY the DB owner can create/delete
users?

If so, is there any way of specifying the user/pass of
the owner when adding a user through code so that it's
possible for whoever is logged in?

Thanks in anticipation...

John C

To answer my question... I needed to add them to the
Admins group.

duh.

J


>-----Original Message-----
>Hi all,
>
>I have a user in my DB, I want that user to be able to
>create users/delete users.
>
>What permissions do I need to set for this to be allowed?
>
>I've set "Administer" on the user's permissions, but
this
>hasn't made any difference.
>
>Is it the case that ONLY the DB owner can create/delete
>users?
>
>If so, is there any way of specifying the user/pass of
>the owner when adding a user through code so that it's
>possible for whoever is logged in?
>
>Thanks in anticipation...
>
>John C
>.
>

Right; and that's one of the key reasons for shipping a different mdw than
the one you secure your database with. The Admins group in your developer
mdw is not the same as the Admins in the production mdw. You may not want
to grant these users all the permissions that the Admins group has.
Shipping a separate production mdw, means they don't get more permissions
than you intend.

--
Joan Wild
Microsoft Access MVP

"John Crighton" <(E-Mail Removed)> wrote in message
news:0c7d01c35b59$c2955790$(E-Mail Removed)...
> To answer my question... I needed to add them to the
> Admins group.
>
> duh.
>
> J