locked
Least permissions to Drop and Create User and assign permissions? RRS feed

  • Question

  • Hello, what are the least permissions to grant a DB User to Drop/Create Users & grant permissions like assign newly created User into db_owner role?

    Thanks in advance.

    Friday, July 26, 2019 5:50 PM

Answers

  • Hello, what are the least permissions to grant a DB User to Drop/Create Users & grant permissions like assign newly created User into db_owner role?

    One likes to hope that to grant someone membership in the db_owner role, you need to be member of db_owner yourself...


    Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

    Friday, July 26, 2019 9:30 PM

All replies

  • Hello, what are the least permissions to grant a DB User to Drop/Create Users & grant permissions like assign newly created User into db_owner role?

    One likes to hope that to grant someone membership in the db_owner role, you need to be member of db_owner yourself...


    Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

    Friday, July 26, 2019 9:30 PM
  • Hi techresearch7777777,

    In addition, requires ALTER ANY USER permission on the database. Please  refer to CREATE USER (Transact-SQL).

    Hope this could help you.

    Best regards,
    Cathy Ji

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to  MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Monday, July 29, 2019 7:30 AM
  • That's what I kind of thought one needs to be within db_owner role to be able to grant db_owner to another DB User.

    Thanks for the replies.

    Monday, July 29, 2019 8:12 PM