Partners
Oracle PHP Generator online Help
| Prev | Return to chapter overview | Next |
Record-level security
Use the Record level permissions window to let each user access only to his own data. To implement the row level security,
| • | The table must have an additional column, to hold the user ID. |
| • | Select the User ID column as Owner field name and set permissions for the record owner and other users. |
| • | For table-based authorization specify the User ID column at the Security Option window, for hard-coded authorization user name will be used as User IDs. This is not applicable for the database server authorization, in that case the grants should be set with the server facilities. |
See the corresponding article for details on how to implement the row level security in MySQL 5.0 and higher using such MySQL features as views and triggers.
| Prev | Return to chapter overview | Next |
