Adding a new user - what permission is required?

[John Crighton]

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

 

[John Crighton]

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

duh.

J

 

[Joan Wild]

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.