# Cannot create reference to df\_sys\_user table

**URL:** <https://community.dreamfactory.com/t/cannot-create-reference-to-df-sys-user-table/881>\
**Category:** Schema & Data\
**Created:** [February 25, 2015, 1:39am UTC](https://community.dreamfactory.com/t/cannot-create-reference-to-df-sys-user-table/881 "2015-02-25T01:39:29Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![steven](https://avatars.discourse-cdn.com/v4/letter/s/94ad74/32.png) [@steven](https://community.dreamfactory.com/u/steven)\
**Post date:** [February 25, 2015, 1:39am UTC](https://community.dreamfactory.com/t/cannot-create-reference-to-df-sys-user-table/881/1 "2015-02-25T01:39:29Z")

</div>

Hi,

Big fan of Dreamfactory, thanks for creating such an awesome product.

The issue I am having is when I add a field with the type of “user\_id” to a database schema and try to get the records using the API Docs with the related parameter set to an asterisk “\*” It returns the following:

```
{
  "error": [
    {
      "context": null,
      "message": "Table 'df_sys_user' not found.",
      "code": 404
    }
  ]
}

```

It appears that I cannot create a reference to the user’s table. Is this not allowed or is there some permissions I can change to achieve this.

I am using Dreamfactory 1.9.0 and it was installed using Bitnami on AWS

Any help is appreciated!

Thanks

---

<div class="post-metadata">

**Author:** ![jeffreystables](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/jeffreystables/32/173_2.png) [@jeffreystables](https://community.dreamfactory.com/u/jeffreystables)\
**Post date:** [February 25, 2015, 2:00pm UTC](https://community.dreamfactory.com/t/cannot-create-reference-to-df-sys-user-table/881/2 "2015-02-25T14:00:20Z")

</div>

Currently, for security reasons, you are not permitted to fetch the user as a related record. `related=*` includes the user, which is not accessible by the service making the request. Your reference is set up correctly and working, you’re just not permitted to retrieve user via the `related` parameter.

---

<div class="post-metadata">

**Author:** ![steven](https://avatars.discourse-cdn.com/v4/letter/s/94ad74/32.png) [@steven](https://community.dreamfactory.com/u/steven)\
**Post date:** [February 25, 2015, 6:07pm UTC](https://community.dreamfactory.com/t/cannot-create-reference-to-df-sys-user-table/881/3 "2015-02-25T18:07:49Z")

</div>

OK, thanks for getting back to me!
