When a regular site user with 'create user' perm adds a user, it is activated automatically, regardless of core Drupal user settings.

Scenario:

* As administrator, visit admin/user/settings
* In the 'Public Registration' section, select Visitors can create accounts but administrator approval is required.
* In the 'Account activation email' section, enable Notify user when account is activated.
* Give Authenticated User role permissions to 'create users'.
* Login as a regular site user
* Create a user at user/add
* Notice that the user is automatically activated.

Expected results:

1) User account is created. [success]
2) Administrator is notified of new account, pending approval. [fail]
3) User account state is not activated. [fail]
4) User receives core message: 'Welcome, awaiting administrator approval'. [fail]
5) User receives core message: 'Account activation email'.