Announcement

Collapse
No announcement yet.

User need to see only their "own" records

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • User need to see only their "own" records

    Hi,

    I've the following problem:

    A user logs in and based on his user ID, he is only allowed to see records in other tables that have his user_id.

    Is this implemented in SC by default or do I need to 'program' this by myself?

  • #2
    As it's user logic, you need to 'program' that yourself. I put 'program' between '' because it's really simple to do: after login put the userid into a global variable in the onvalidateok event: [glob_userid]={userid}; At the select add this to the sql statement generated (WHERE) user_id=[glob_userid]
    That's all.
    Albert Drent
    aducom software netherlands
    scriptcase partner, reseller, support and (turn-key) development
    www.scriptcase.eu / www.scriptcase.nl

    Comment

    Working...
    X