unrecognized configuration parameter "rls.ihp_user_id"
Hi everyone,
I'm getting an issue when I try to create a post with a foreign key relationship to the users table. The user_id column has a default value of ihp_user_id().
I can create posts again when I remove the column.
This is the error: unrecognized configuration parameter "rls.ihp_user_id"
I'm also getting this error now when trying to run a migration with a policy that uses the ihp_user_id() function.
Is there somewhere I need to add this function or enable it?
Manborough I could, but I thought this was a function provided by IHP to access the current user id.
This is from the docs.
The ihp_user_id() is a database function provided by IHP that returns the user id of the logged in user of the IHP application.
marc PROYeah, but you're very likely not using Row level security for authentication, so then this function will not work as expected, even if it was defined :)
Manborough I assume there's more to be done besides adding ensureAuthenticatedRoleExists to the FrontController and ALTER TABLE posts ENABLE ROW LEVEL SECURITY in my migrations?
Or do I need to define the ihp_user_id function myself? I couldn't see any sql statements in the DataSync.Role module.
Thanks for your help so far.
Can you remove the default value
ihp_user_id()?