Post reply

sysadmin database-level permissions

  • April 8, 2015 at 1:30 pm

    #299743

    Would there be a reason to explicitly add Username to msdb (or any other database for that matter) if Username is already assigned the sysadmin server role?

    I thought not, but I'm seeing occurrences of it all over our system with nothing more granular being added or taken away. Seems pointless.

  • April 8, 2015 at 1:37 pm

    #1789687

    could it be a legacy of a normal user who got access to multiple databases, and then someone upgraded them to sysadmin, because they needed more and more access to multiple dbs?

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • September 11, 2015 at 12:48 am

    #1825885

    If user is member of sysadmin fixed server role they can perform any activity in the server.

    There is no meaning of mapping user explicitly to msdb database.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply