Managing MS Project Database users

From: Pedro Caetano Barros (pbarros@scopus.com.br)
Date: 05/17/02 

From: "Pedro Caetano Barros" <pbarros@scopus.com.br>
Date: Fri, 17 May 2002 10:09:22 -0700

Hi Pedro,

We are using SQL Server authentication and connecting via
a DSN to provide project managers the ability to save
their MS Project 2000 projects into a SQL Server Database.
All users can use the DSN effectively, but they also have
the ability to access any project. My need is to grant
users access in a way that each user could access ONLY his
projects, and wouldn't be able to access other managers'
projects.

Then I'm looking at how to properly configure SQL
Server rights so people can only access the project data
they are allowed to view even though it is in the same
database. The ODBC connections are used with SQL-Server
authenticated logon.

I already have looked for help at Project 2000 newsgroup
and after some discussions, people there indicate me this
newsgroup because the issue relates more specifically with
SQL Server security.

We use SQL-Server 2000, MDAC 2.6 and Project 2000. Each
manager has a DSN configured at his machine, pointing to
the same corporative SQL-Server database.

Would it be possible to solve this problem?

Thanks for any help.

Regards,

Pedro Caetano Barros
São Paulo
Brazil

Relevant Pages

  • Managing Project 2000 Database users
    ... their MS Project 2000 projects into a SQL-Server Database. ... All users can use the DSN effectively, ... the ability to access any project. ... and wouldn't be able to access other managers' ...
    (microsoft.public.sqlserver.security)
  • Req: Senior .Net Software Engineer required
    ... Conduct technical studies and evaluations of business area ... Ability to handle multiple projects, ... Technical Skills: ... and cardinality with a focus on MS SQL Server. ...
    (comp.os.linux.setup)
  • cannot access website
    ... Nerve.com--this started a few weeks ago; I do not get the error message on ... Microsoft OLE DB Provider for ODBC Drivers Error '80040e4d' ... Not defined as a valid user of a trusted SQL Server connection. ... The DSN used to connect to the Commerce database is misconfigured to use ...
    (microsoft.public.windows.inetexplorer.ie6.browser)
  • RE: Invalid authorization specification
    ... Does your application use a DSN to connect to SQL Server? ... DSN is setup correctly on the client machine. ... How to troubleshoot connectivity issues in SQL Server 2000 - ...
    (microsoft.public.sqlserver.connect)
  • Re: Programmatically create DSN usind SQL Server Authentication
    ... Not when you create the DSN programmatically. ... >Server using SQL Server Authentication. ... >is off-topic for my purpose because it only shows Windows authentication. ...
    (microsoft.public.sqlserver.odbc)