locked
level of permission for sercurity accounts on DB/Sqlserver level RRS feed

  • Question

  • what level of permission will have in sql server level,databse level?

    filled with some known information...............

    Db engine service accont---db_owner on system databases,..?

    Agent account ----owner level on msdb,

    ssrs account ----?db_owner (reportserver database)

    ssis account -----?

    ssas account--?

    filled with some information..not sure if it correct/howmuch it is correct

    if possible some one can provide those internal level of access for service accounts on SQL Server?

    Thanks for help


    -

    • Moved by Shulei Chen Tuesday, September 11, 2012 8:07 AM (From:Getting started with SQL Server)
    Monday, September 10, 2012 7:21 PM

Answers

  • Thanks for answer, but to make more clear for me,

    what are the permissions that sql process have ? on what database?

    Pls help


    -


    Hi,

    Thanks for the update.

    Please take a look at this article: Permissions (Database Engine). It provides a complete list of SQL Server permissions including server lever and database level.


    Best Regards,
    Ray Chen

    • Marked as answer by Shulei Chen Tuesday, September 18, 2012 9:14 AM
    Wednesday, September 12, 2012 5:54 AM

All replies

  • Hi,

    Each service in SQL Server represents a process or a set of processes to manage authentication of SQL Server operations with Windows. And the needed service account permissions are assigned automatically during installation or when the service account is changed using SQL Server Configuration Manager (SSCM). You could assign permissions manually but it is generally recommended to let SQL Server installation or SSCM do so automatically. For more details, please refer to the following resources:

    • http://msdn.microsoft.com/en-us/library/ms143504.aspx
    • http://social.msdn.microsoft.com/Forums/en-US/sqlgetstarted/thread/50b490c0-1f4a-4cc2-8e1a-202e9f9b0922

    TechNet Subscriber Support

    If you are TechNet Subscription user and have any feedback on our support quality, please send your feedback here.

     

    Best Regards,
    Ray Chen

    Tuesday, September 11, 2012 8:25 AM
  • Thanks for answer, but to make more clear for me,

    what are the permissions that sql process have ? on what database?

    Pls help


    -

    Tuesday, September 11, 2012 7:37 PM
  • Thanks for answer, but to make more clear for me,

    what are the permissions that sql process have ? on what database?

    Pls help


    -


    Hi,

    Thanks for the update.

    Please take a look at this article: Permissions (Database Engine). It provides a complete list of SQL Server permissions including server lever and database level.


    Best Regards,
    Ray Chen

    • Marked as answer by Shulei Chen Tuesday, September 18, 2012 9:14 AM
    Wednesday, September 12, 2012 5:54 AM