Accessing SQL tables

1. 1. 1. Tutorial

Setting up role-based access to SQL tables.

1. 1. 1. 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.

1. 1. 1. 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

1. 1. 1. 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.