Managing MS Project Database users
From: Pedro Caetano Barros (pbarros@scopus.com.br)
Date: 05/17/02
- Next message: papppp: "Re: using the same login name TWICE?"
- Previous message: Pankul Verma: "Re: major security concern - any sql user with minimal permission can see code for all stored procs and triggers"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
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
- Next message: papppp: "Re: using the same login name TWICE?"
- Previous message: Pankul Verma: "Re: major security concern - any sql user with minimal permission can see code for all stored procs and triggers"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
