Securing a Single Table A97

[Kahuna]

I have a secure back/front-end app in A97. Works fine and some of the config
data is held in a second secure database, which can only be accesses by a
RWOP query in the front-end.

What I'd like to do is have an - Unsecured backend - but with one table
secured to the app workgroup. i.e. only openable where the backend is opened
using the WKGRP user and password relevant.

The backend (other than this single table) should be openable with just the
system.mdw as normal.

Is this possible and how might I set this single table security using the
app WKGRP.

Any suggestions gratefully received.


Cheers

 

[Joan Wild]

What you would do is actually secure this 'unsecured backend' using the same
workgroup file. Restrict permissions on this one table, and then give full
permissions to the Users Group for all the other tables.

When using the system.mdw, the user will be logging in silently as Admin, a
member of the Users Group, and there be able to do everything, except they
won't be able to open your restricted table, since the Users Group won't
have permission to it, and the Admin user won't own it.

 

[Kahuna]

Excellent feedback thanks Joan - that's where I thought it would go - was
confused about admins though. I thought if admins had access they could
override the security - removed admins group from my secured tables!

Much appreciated

 

[Joan Wild]

The Admins Group is different in each mdw. Only the Admin User and the
Users Group is common to all mdws. So if you secure it with your secure
mdw, the Admins Group in system.mdw won't have the same permissions as the
Admins Group in your secure mdw.