Gossamer Forum
Home : Products : DBMan SQL : Discussion :

Add permisson for users of one table out of four ?

Quote Reply
Add permisson for users of one table out of four ?
Hi and a great new GT year to you all !
Basic question: I have four tables with all users sharing a common user table. All registered users can view all tables, but with one table they can ADD their contributions, and be the only ones to view, modify or delete these (and the administrator of course who gives his final validation to publish a contribution for all to see) ?

I know it's a combination in the table setup menu but I cann't get it right!
Thanks for your 2003 wisdom!
Charly
Quote Reply
Re: [charly] Add permisson for users of one table out of four ? In reply to
Hi Charly,

Thanks, a happy new year to you too Sly

There are some simple steps to make it up:

- add user_id field to that table.
- Set user_id as auth_user_field option ( Admin - Tables - Setup ).
- Switch auth_modify_own and auth_view_own options to 'Yes'

Now the registered users can add/modify/delete their own records.


TheStone.

B.
Quote Reply
Re: [TheStone] Add permisson for users of one table out of four ? In reply to
Thanks - that's one thing I tried, without success.
ie.
auth_no_authorisation : No
auth_allow_default: View
auth_sign_up : Yes
auth_signup_permissions : View,Add,Modify,Delete
auth_modify_own : No ===> Yes
auth_view_own : No ===> Yes
auth_user_field : User
auth_logoff : URL etc

The two fields: in No position I get the expected display of all records in the table. In the Yes position, the same link triggers an error page "Your search returned no results"

Since, unfortunately I have deleted my GT sample files, is there somewhere I can check a 'virgin' table's templates and its config setups, and more precisely to check the code of the main templates involved (such footer.html and search_results.html)? I suspect my problems stems from these.
Thanks