I want to create authentication apis in Hasura. My user can have differrent roles when signing up. Thinking of maintaining an Enum table for the same. So that I can have a foreign key/type from it in the user table. However, I intend to create a postgress trigger on this enum table, such that everytime, new role is added, a new hasura role should also be created to allow for JWT authentication and authorization accordingly. Where does hasura stores its Hasrua role.
Where are Hasura roles stored?
225 Views Asked by Rohit Bokade At
1
There are 1 best solutions below
Related Questions in POSTGRESQL
- Why does adding a JOIN completely modify the query planner behaviour?
- When dealing with databases, does adding a different table when we can use a simple hash a good thing?
- Aggregate and count in PostgreSQL
- Rails HABTM: Select everything a that a record 'has'
- Trigger using data from inserted row
- Select results where joined table contains records with an attribute, but without another
- DB candidate as CouchDB/Schema replacement
- How do I properly add data in SQLAlchemy?
- Postgres in Conda Environment (Ubuntu 14.04)
- How to customize the output of the Postgres Pseudo Encrypt function?
- Split a large query (2 days) into pieces to increase the speed in Postgres
- Why does pg_search prefix not work like I expect?
- extracting meta info from a table psql using information_schema
- How to query a table in the database and copy it's data into one one?
- Update a table using info from a second table and a condition from a third table in Postgresql
Related Questions in ROLES
- Dynamic roles list in CustomAuthorize ASP MVC
- Roles class asp.net mvc?
- Assigning Roles in AspNetUserRoles table made by Identity
- Wordpress - How to create new post from form without admin review?
- Meteor.users.find() - how to filter by group in alanning:roles package
- How do I assign specific roles to each user in rails?
- Change role of one user no working with Symfony2
- MVC Role Authorization not working for windows accounts
- Authorize attribute doesn't work in MVC
- Best Practices for Roles vs. Claims in ASP.NET Identity
- Find all users with specific Roles in Entrust for Laravel 5
- User specific content in Symfony
- When to use an application role in a database?
- Deploy scoped roles for web app in weblogic portal
- Laravel multiple midleware for some route
Related Questions in HASURA
- Type query_root must define one or more fields
- How can I integrate hasura postgre data into an existing Wordpress site?
- set default error messages for mutations in Hasura
- Composite Key support
- Hasura GraphQL query order by nested array relationships (with only one element)?
- How to connect to postgres read replica in Hasura
- Hasura on Google Cloud Run - Monitoring
- Graphql Error: Network Request Failed only in Android
- Cannot read property 'affected_rows' of undefined when trying to run an Hasura mutation
- Does Hasura 'Event Triggers' support triggers for their internal tables?
- GraphQL : Error while adding computed fields
- GraphQL : OverLoaded function error when adding a computed field
- Writing Postgres function for Hasura
- How to convert Postgres bytea to base64 string
- How to insert an object and related array objects in one mutation
Related Questions in HASURA-JWT
- How to map correctly to make `x-hasura-allowed-roles` field an array using claims_map in Hasura?
- Error when encoding and decoding jwt on next-auth
- having problem with graphql and magic api . how to apply mutations and queries on a server to create a schema
- Resource does not exist error on hasura while github ci cd
- Creating new roles Using Hasura metadata API
- How do you test out Hasura authorization?
- Issue configuring JWT secret with claims_map in Hasura Docker compose
- Hasura - Different Permission for different pages (in web application) on same table for same user / role
- Hasura object permission based authorization
- Hasura crashed while going through the tutorial
- Where are Hasura roles stored?
- claims key: 'https://hasura.io/jwt/claims' not found
- custom roles in hasura using firebase auth and jwt
- Hasura Auth Clarifications
- Hasura Graphql JWT Issue
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Answer 1 (direct answer)
Not sure this is something the app developer should edit.
All Hasura metadata (including roles/permissions) is in Postgres.
The schema is "hdb_catalog". The table is "hdb_metadata".
You can query this using:
It contains a large JSON document. It's better to look at it using PGAdmin.
Answer 2 (dynamic roles)
It looks like you're trying to get dynamic roles in place. There is a great Youtube video that explains how to model it:
https://youtu.be/-18zZO3DrLY?t=1370