Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2003
    Location
    Boston, MA
    Posts
    2

    Cool Unanswered: How to setup permissions by using field value?

    Hello, I need some help. I am modifying a database that will be accessed by people in different parts of the world. I am trying to set user roles to show only records in each Location. Here is an example:

    User Groups
    Boston Users
    New York Users
    London Users


    Database: machines
    Table: tblmachines
    fldname fldoperatingsystem fldgeocenter
    --------- ----------------------- ---------------
    foo.mydomain.com Windows 2000 BOSTON
    loo.mydomain.com Windows NT 4.0 NEW YORK
    moo.mydomain.com REDHAT LINUX LONDON

    How do I configure user roles so that only users from Boston see Boston records, and users from New York see New York records etc etc? I am trying to key off the fldgeocenter field… Any suggestions would be MOST welcome.

  2. #2
    Join Date
    Feb 2003
    Location
    Montreal, Canada
    Posts
    117

    Re: How to setup permissions by using field value?

    User Roles doesn't help here.
    The database roles does not help here.
    The best way to filter the records horizontally is to implement stored procedures where "fldgeocenter" would be an input parameter. Use the value of that param. to filter the records in the WHERE statement.

    Originally posted by dperrott
    Hello, I need some help. I am modifying a database that will be accessed by people in different parts of the world. I am trying to set user roles to show only records in each Location. Here is an example:

    User Groups
    Boston Users
    New York Users
    London Users


    Database: machines
    Table: tblmachines
    fldname fldoperatingsystem fldgeocenter
    --------- ----------------------- ---------------
    foo.mydomain.com Windows 2000 BOSTON
    loo.mydomain.com Windows NT 4.0 NEW YORK
    moo.mydomain.com REDHAT LINUX LONDON

    How do I configure user roles so that only users from Boston see Boston records, and users from New York see New York records etc etc? I am trying to key off the fldgeocenter field… Any suggestions would be MOST welcome.
    Steve

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •