User rights and SOX

From: jaylou (jaylou_at_discussions.microsoft.com)
Date: 07/21/05

  • Next message: Narayana Vyas Kondreddi: "Re: Backup" 
    Date: Thu, 21 Jul 2005 07:56:08 -0700

    First question:
    I have a user that is admin on the server to perform security patches and
    general server maint. He is also a user in SQL. Since he is the Admin of
    the box he has also inherited Admin rights to SQL. I want him to have only
    "select,insert,update and delete" rights to all tables but no other rights in
    SQL.
    Is this possible?

    2nd question:
    Has anyone out there needed to separate SQL functions for SOX? If so can
    you please give me some ideas of how you separated SA and DBO functions?
    SA(insert, update, delete)
    DBO (create tables,give user rights etc..)
    Thanks,
    Joe

  • Next message: Narayana Vyas Kondreddi: "Re: Backup"

    Relevant Pages

    • Re: How do I find I am administrator?
      ... That depends up on the type of authentication you are using to access SQL ... If you have admin rights then execute the below command from Master ... enterprise manager on server where sql 2000 server is installed? ...
      (microsoft.public.sqlserver.server)
    • Re: How do I find I am administrator?
      ... That depends up on the type of authentication you are using to access SQL ... If you have admin rights then execute the below command from Master ... enterprise manager on server where sql 2000 server is installed? ...
      (microsoft.public.sqlserver.tools)
    • Re: How do I find I am administrator?
      ... That depends up on the type of authentication you are using to access SQL ... If you have admin rights then execute the below command from Master ... enterprise manager on server where sql 2000 server is installed? ...
      (microsoft.public.sqlserver.setup)
    • Re: How do I find I am administrator?
      ... That depends up on the type of authentication you are using to access SQL ... If you have admin rights then execute the below command from Master ... enterprise manager on server where sql 2000 server is installed? ...
      (microsoft.public.sqlserver.clients)
    • Re: How do I find I am administrator?
      ... That depends up on the type of authentication you are using to access SQL ... If you have admin rights then execute the below command from Master ... enterprise manager on server where sql 2000 server is installed? ...
      (microsoft.public.sqlserver.connect)