Password Protection

[jlc]

I am using MS Project 2000 and saving the files into a SQL Server database. How can I password protect my files?

 

[Rob Schneider]

Put security on the SQL Server database...

Hope this is useful to you. Let us know.

rms

 

[jlc]

There are multiple users saving into the same database. Can we put security on the database at the file level?

 

[Rob Schneider]

I guess, based on what you are saying, that your are storing full files
as records in the database? That's rather unconventional, but I guess
not impossible. I don' think SQL Server has record level security
(since each file would be a record). Check with your SQL Server
admininstrator and/or the DBA.

More conventionally you would store the project data in a SQL server
database specific for Project. Again, security can be applied. Check
with your SQL Server administrator and/or the DBA.

Hope this is useful to you. Let us know.

rms

 

[jlc]

The database was setup specifically for project. If you were to link to a single MS Project file using MS Access, you would see the same tables, and fields. SQL server is setup to allow multiple files to be saved into the same database. The only problem is I can only use groups at the database level to grant access rights. A user has the same access to each of the files. I just thought someone else might have run into this situation and there might be a 3rd party product out there I could use to set the access at the file level.