Adding a new user - what permission is required?

  • Thread starter Thread starter John Crighton
  • Start date Start date
J

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
 
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.
 
Back
Top