Hi, im trying to set up a database collection so users from the client-side can only view/interact with their own row, so if they are signed in to the correct account. How can i do this? In similar tools you can set access rules, so if logged in user email is equal to specific row allow access, where is this in appwrite?
Summary
To make users only able to view their own entry in the collection, you can follow these steps:
1. Set the collection permission so any user can only create documents.
2. Create a function triggered when a new document is created in the collection.
3. Inside the function, adjust the permissions to allow the user to also read the document.
Here is an example of how to implement this in your function:
```ts
const currentUserId = req.variables.APPWRITE_FUNCTION_USER_ID ?? null;
if (currentUserId !== null) {
await databases.createDocument(
'[DATABASE_ID]',
'[COLLECTION_ID]',
{},
[
Binyamin
May 23, 2023, 21:01
You can go one of two ways.
Binyamin
May 23, 2023, 21:05
Set the collection permission so any user can only create documents.
Then, create a function and let to be triggered new document is created in the collection.
If for example the collection id is aaaaaa then this would be the right trigger for it databases.*.collections.aaaaa.create
Then inside that function you can adjust the permissions to allow the user to also read the document.
Binyamin
May 23, 2023, 21:09
Move everything to a function.
Block any access to your collection
And inside your function you can use the variable APPWRITE_FUNCTION_USER_ID to get the user id and then do something like this