Re: How to control the security in this case?

From: Uri Dimant (urid_at_iscar.co.il)
Date: 07/19/05

  • Next message: Ivan: "Re: How to control the security in this case?"
    Date: Tue, 19 Jul 2005 10:06:46 +0300
    
    

    Hi, Alejandro
    I'm afrais that does not solve the problem. I still keep seeing the DTS's
    created by others.

    "Alejandro Mesa" <AlejandroMesa@discussions.microsoft.com> wrote in message
    news:B1A8ECBE-047C-4095-889A-A7DA9C4BFD04@microsoft.com...
    > Open the packages in design mode, use "save as" and set the owner and user
    > password.
    >
    >
    > AMB
    >
    > "Ivan" wrote:
    >
    > > 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: Ivan: "Re: How to control the security in this case?"

    Relevant Pages

    • How to control the security in this case?
      ... I have a SQL Server 2000 in my head office, it has several databases. ... one of the databases is maintained by a colleague of a regional ... we have developed some DTS packages in head office ...
      (microsoft.public.sqlserver.security)
    • Re: Migration Question Again...
      ... You have to migrate the system databases too, specifically Master and MSDB ... As soon as you restore the Master and MSDB all your ... all DTS packages wil be in MSDB database. ...
      (microsoft.public.sqlserver.setup)
    • Migrating DTS to several locations
      ... I have over 182 DTS packages that reside on 54 SQL servers each is a diffrent ... server, the DTS packages pull data from SQL server databases, sybase & ... The plan is to move the databases to 4 SQL servers, ...
      (microsoft.public.sqlserver.dts)
    • what Permissions to Exec DTS ?
      ... We have lots of DTS packages doing all sorts of stuff like ... granting any access on other user databases? ...
      (microsoft.public.sqlserver.security)
    • Re: copying data from 1 table to another
      ... Staging or temporary tables seems very ... Not familiar with DTS packages imagine there is a bit of a learning ... "John Bell" wrote: ... > databases!!! ...
      (microsoft.public.sqlserver.server)