Use external tables instead of Directus internals

[awesome-developer-20]

Feature Request:

Use external tables instead of Directus internals. For example, instead of using directus_users use users for authentication or instead of directus_files use media on users database.

---

Original post:

My client already has users roles database setup for his organisation in a weird and unconventional way and they want to use that same data for directus portal login.

I've wrote a separate API for authentication which takes email and password in request and returns it's roles if user is successfully authenticated and null if not.

Is there a way where instead of duplicating the data in directus_users table, I could use the above mentioned API?

[joselcvarela]

Hello @awesome-developer-20
From what I can tell, every login will need to have a record in directus_users as you can see here:

directus/api/src/services/authentication.ts

Lines 60 to 80 in 86b7f7f

	const user = await this.knex
	.select<User & { tfa_secret: string | null }>(
	'u.id',
	'u.first_name',
	'u.last_name',
	'u.email',
	'u.password',
	'u.status',
	'u.role',
	'r.admin_access',
	'r.app_access',
	'u.tfa_secret',
	'u.provider',
	'u.external_identifier',
	'u.auth_data'
	)
	.from('directus_users as u')
	.leftJoin('directus_roles as r', 'u.role', 'r.id')
	.where('u.id', await provider.getUserID(cloneDeep(payload)))
	.andWhere('u.provider', providerName)
	.first();

So I am afraid your scenario will not be possible.
Depending on what you are trying to achieve, it may be possible to create a single user on Directus to requests data then have a custom authentication logic so users can have access to this user or not.

[awesome-developer-20]

Thanks a lot for your quick reply 🙂

I have thought of doing that but I need username of the logged in user.

I've a frontend application that uses directus sdk to login where users can raise an issue. So, I need to map user that raised issue with the issue.

[awesome-developer-20]

Ok no worries. I'll try to implement it someway but it would be good to see something like this in future where I could store users and roles my way and somehow use directus auth app component and api with it.

Thanks for your help and support 👍

[awesome-developer-20]

If possible mark this as potential future feature of directus 🙂
EDIT: I've moved this discussion from "Q&A" to "Ideas"

Something like #10141 (comment)

[rijkvanzanten]

Heya! Thank you for taking the time to submit this request!

It has been over 90 days, and this discussion has not received at least 15 votes from the community. This means that we don't feel like there's enough community interest to warrant further R&D into this topic at this time. 🧊

This request will now be closed to keep our discussions tidy. Please reach out if you have any questions!

For more information, see our Feature Request Process.