How to control the security in this case?

From: Ivan (Ivan_at_discussions.microsoft.com)
Date: 07/18/05

  • Next message: Uri Dimant: "Re: ODBC and SQL Security" 
    Date: Sun, 17 Jul 2005 20:47:01 -0700

    Dear all,

    I have a SQL Server 2000 in my head office, it has several databases.
    However, one of the databases is maintained by a colleague of a regional
    office. He has the all the authority (read / write) to work on this database.
    But there is a problem, we have developed some DTS packages in head office
    and this colleague is going to make his own packages. We would like to have a
    control that this colleague is not able to access our DTS packages (not even
    read), he can only opens his own the DTS packages.
    Is there any control to achieve this purpose? Please advise. Thanks a lot.

    Ivan

  • Next message: Uri Dimant: "Re: ODBC and SQL Security"

    Relevant Pages

    • Re: How to control the security in this case?
      ... > AMB ... one of the databases is maintained by a colleague of a regional ... >> and this colleague is going to make his own packages. ... he can only opens his own the DTS packages. ...
      (microsoft.public.sqlserver.security)
    • Re: Data driven people arguments
      ... databases are good at, then even if there's just a little of that, I ... >implemented as a stored procedure; I'm fine with it because up to now ... >Now my colleague says that it's better to put the logic into the sp; ... >able to convince each other. ...
      (comp.object)
    • Recover database without backup
      ... The Windows 2000 server Oracle was running on crashed, ... Most of the Oracle databases that were on the machine prior to the crash had ... colleague has had no luck thus far with this method. ...
      (comp.databases.oracle.server)
    • Re: Data from Remote databases
      ... Check out linked servers. ... > Should i have to restore all 40 databases into my head office db for the ... > purpose of data in 6-8 tables ??? ...
      (microsoft.public.sqlserver.security)
    • Re: Data from Remote databases
      ... Should i have to restore all 40 databases into my head office db for the ... purpose of data in 6-8 tables ??? ... > make reports through that server. ...
      (microsoft.public.sqlserver.security)