SQL Server Performance

A new structure of permissions.

Discussion in 'SQL Server 2008 General DBA Questions' started by LucasDa, Apr 7, 2010.

  1. LucasDa New Member

    Hi, my Name is Lucas and need help in SQL. . . .
    I'm working in a company where the DBA position is new, this company has never had a DBA. For this reason I'm responsable to do a lot of new tasks and one it's to develop a new structure of permissions for the SQL Server.
    This company have "Developers", "Architects", "Systems Analyst", "Systems Engineers" and now "DBA". I need to develop a new structure of permissions in order to that these persons can to connect to the SQL Server.
    I neew some example or advice to develop this task.

    Tthank you very much....!!!!!
    LucasDa, Apr 7, 2010
    #2

  2. Luis Martin Moderator

    You have to think in terms like:
    Who can read and write in user databases?
    Who can only read in user databases?
    Who can access (read, write or both) in production databases and in test databases.
    No one, except you (DBA) can have sa permissions.
    Luis Martin, Apr 8, 2010
    #3

  3. satya Moderator

    satya, Apr 19, 2010
    #4

Share This Page