Linking to Secured Db

[Kahuna]

Hi Folks

I have a secure App and use several other Db's which I link to.

Currently all the Dbs I link to are unsecured. Is there a way to link -
using Transfer Db or other link code, to a secure Db using the same mdw as
the App? Cant discover the user name / password syntax (if it exists) to
link whilst secured.

Cheers

 

[Tim Ferguson]

Currently all the Dbs I link to are unsecured. Is there a way to link
- using Transfer Db or other link code, to a secure Db using the same
mdw as the App? Cant discover the user name / password syntax (if it
exists) to link whilst secured.

You don't need to. The user and group membership will be parsed against the
permission in the back end anyway, so if Greig in DataEntry doesn't have
access to BankDetails, then he won't be able to see it.

You can get results by using the WITH OWNERACCESS OPTION in queries, which
means that _you_ create the queries against tables that _you_ have
permissions on, and they'll run because you are the owner of the query. You
can then grant Read or Execute or Write permissions for that query to other
users, who can then get at the data only via what you have allowed in the
query.

I am not sure I have explained that very well, but you can check help files
for "RunPermissions Property". Hope it helps, anyway


Tim F

 

[Kahuna]

Thanks Tim, that puts it in perspective. I am used to the Access Security
setup and RWOP queries I just couldn't get my head around the linking -
seems I have had failures in the past just linking to the secure backend -
but that's probably a RWOP issue.

Well explained thanks.

Cheers