Accessing SQL tables
From DreamFactory
| Line 1: | Line 1: | ||
### Tutorial | ### Tutorial | ||
| − | Setting up role-based access to SQL tables | + | Setting up role-based access to SQL tables. |
### Background | ### Background | ||
| − | Roles govern HTTP access to the REST API endpoints in DreamFactory. When you set up a SQL database in the 'Services' tab, no tables are accessible by default (unless you are a DreamFactory Admin). | + | Roles govern HTTP access to the REST API endpoints in DreamFactory. When you [set up a SQL database](http://wiki.dreamfactory.com/DreamFactory/Tutorials/Connecting_to_SQL) in the 'Services' tab, no tables are accessible by default (unless you are a DreamFactory Admin). |
You can expose table access by [[DreamFactory/Tutorials/Setting up user roles|setting up user roles]] and granting access to specific SQL tables. | You can expose table access by [[DreamFactory/Tutorials/Setting up user roles|setting up user roles]] and granting access to specific SQL tables. | ||
Revision as of 18:24, 23 October 2015
- Tutorial
Setting up role-based access to SQL tables.
- Background
Roles govern HTTP access to the REST API endpoints in DreamFactory. When you [set up a SQL database](http://wiki.dreamfactory.com/DreamFactory/Tutorials/Connecting_to_SQL) in the 'Services' tab, no tables are accessible by default (unless you are a DreamFactory Admin).
You can expose table access by setting up user roles and granting access to specific SQL tables.
- Example - Grant SQL table access for a role.
1. Log into the DreamFactory admin console as an Admin.
2. Click on 'Roles' > 'Create'.
3. In the 'Access' tab, select your SQL database API for 'Service', the table for 'Component', HTTP verbs for
- Example - Create a new role with the REST API
You can operate on roles directly with the API. Click on API docs and view the 'System' API calls.
