Post reply

Been out of roulation for a year - question about users

  • November 29, 2016 at 6:57 am

    #332276

    Ok, I have been in another IT branch for almost a year, but this week I got an sql question to setup security for users on an SQL Server 2012.

    Now the t-sql for the required security settings was a easy task the hard task was determining which users were to get the security and now I have to admit I've forgotten a few things.

    I'm doubting what a few users are, and my current job don't rally have access to an sql environment to "play" with.

    I'm seeing a few users which I can't rly shake the doubt that their system users.

    The following users can somebody tell me wheter their important or not:

    *BCK

    *JCM

    *jcm

    *mapadmin

    *mapadmininst

    *user with the same name as the database

  • November 29, 2016 at 7:15 am

    #1914942

    They're not SQL system users, but they may be 'system' users for the applications that are running there (users created by the application)

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • November 29, 2016 at 7:20 am

    #1914946

    Thanks

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

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