Linking a unsecured database to a table in a secure database

[Gscbrian]

I am trying to link to a table in a secured database from an unsecured
database. When i try to link I get error message "you do not have the
necessary permisssions to use [PATH] object have your system adminsitator or
the person who created this object establish the appropriate permissions to
you. I worked around this error by connecting to the work group file. But
after disconnecing from the mdw file the table is inaccessible because now I
don't have access. Do I have to secure the backend only? Thanks!

Brian

 

[Rick Brandt]

I am trying to link to a table in a secured database from an unsecured
database. When i try to link I get error message "you do not have the
necessary permisssions to use [PATH] object have your system
adminsitator or the person who created this object establish the
appropriate permissions to you. I worked around this error by
connecting to the work group file. But after disconnecing from the
mdw file the table is inaccessible because now I don't have access.
Do I have to secure the backend only? Thanks!

Brian

If the table is in a file that has been secured then you cannot access it
unless you use the proper MDW file. That is how security works. If you
could connect to a secure file with any old workgroup and any user account
then it would be pretty pointless.

 

[Joan Wild]

The only way you can accomplish this is to grant the Users Group Open
Permission on the Database object, and Read Data permission on the Table in
the secured database.

However, that means that anyone using any workgroup can open the database
and read that one table. May not be what you want.