CREATE USER, User does not have permission to perform this action.

Question

_{Friday, November 2, 2012 8:11 AM}

-- first, connect to the master database
CREATE LOGIN login1 WITH password='Qwerty12345';
CREATE USER login1User FROM LOGIN login1;
EXEC sp_addrolemember 'dbmanager', 'login1User';
EXEC sp_addrolemember 'loginmanager', 'login1User';

After, I connect to database 'master' with 'login1User' and execute:

CREATE LOGIN login2 WITH password='Qwerty12345'; - ok

CREATE USER login2User FROM LOGIN login2; - User does not have permission to perform this action.

All replies (7)

_{Friday, November 2, 2012 2:02 PM}

Hi Vit007,

Can't you just create that second user with the same user (db admin?) you used to create the first one?

Best Regards,
Carlos Sardo

_{Monday, November 5, 2012 6:05 AM}

Hi Vit007,

Can't you just create that second user with the same user (db admin?) you used to create the first one?

Best Regards,
Carlos Sardo

Hi Carlos.

If I create a second user first administrator then everything is OK. But, I need many users whose can create log in.

_{Monday, November 5, 2012 7:46 AM}

Hi Vit007,

Please check the two database role: 'dbmanager' and 'loginmanager'.

CREATE USER Requires ALTER ANY USER permission on the database.

Iric Wen

TechNet Community Support

_{Monday, November 5, 2012 8:18 AM}

Hi Vit007,

Please check the two database role: 'dbmanager' and 'loginmanager'.

CREATE USER Requires ALTER ANY USER permission on the database.

Iric Wen

TechNet Community Support

select rm.*, dp2.name AS 'User', dp1.name AS 'Role' from sys.database_role_members rm LEFT JOIN sys.database_principals dp1 ON rm.role_principal_id = dp1.principal_id LEFT JOIN sys.database_principals dp2 ON rm.member_principal_id = dp2.principal_id

role_principal_id member_principal_id User   Role
6  8  login1 dbmanager

7 8  login1 loginmanager

_{Monday, November 5, 2012 9:08 AM}

Vit 007,

Please run:

GRANT ALTER ANY USER TO dbmanager

or

GRANT ALTER ANY USER TO loginmanager

and do your test again.

Iric Wen

TechNet Community Support

_{Monday, November 5, 2012 11:32 AM}

THX.

_{Monday, March 3, 2014 11:44 AM}

I do it. But error repeat.

CREATE USER login2User FROM LOGIN login2; - User does not have permission to perform this action.