3,452 questions
1
vote
1
answer
85
views
What is the difference between session_authorization and set role
In Postgres, you can set current_user by:
set session_authorization = 'new_user';
and
set role 'new_user';
While I like the shorter syntax, I'm asking if there is a difference in functionality ...
- 3,152
1
vote
1
answer
59
views
Discord.js "guildMemberUpdate" event only fires the second time i change a Nickname
The Issue:
I wanted to create a feature where the bot sets a certain prefix before the Nickname fitting my discord server theme if a user decides to change it. I'm allowing the users to change their ...
- 13
1
vote
2
answers
94
views
Laravel Spatie Role/Permission - Integrity constraint violation: 1048 Column 'team_id' cannot be null ---> insert into model_has_roles
I am using Laravel V:12 and Spatie Role/Permission V:6. for multiple roles (super_admin, sub_admin, user, sub_user). I created one seeder for creating an admin user and its role/permission.
At the ...
- 43
1
vote
1
answer
34
views
JWT and roles per team
I have an authorization scheme for a user. This particular user is member of multiple teams.
In the team MANAGEMENT the user has the role EMPLOYEE
In the team LOCATION_1 the user has the role MANAGER
...
1
vote
1
answer
83
views
How to Implement Role-Based Routing in Flutter with JWT Authentication?
I am a beginner in mobile development using Flutter, and I want to set up role-based routing for my app by creating a separate routing file in Dart. My app uses JWT authentication, and the token is ...
- 11
0
votes
0
answers
114
views
Configuring apache superset with postgres with role and schema
I am trying to configure apache superset with PostgreSQL as metadata database. I provided below sqlalchemy URL:
SQLALCHEMY_DATABASE_URI = "postgresql://superset_user:password@db_host:5432/...
0
votes
1
answer
330
views
Role switch option not present for AWS management account
I am trying to role switch to member account of the organization using my AWS management account. But the role switch option not present as shown in screen shot below.
As you can see this is my ...
- 1,637
-1
votes
1
answer
99
views
Kubernetes role to create limited roles
Is it possible to create a role that gives the right to create roles which can only give the right to create and delete pods, deployments, secrets
For example the role A permit to create roles X,Y,Z ...
- 41
-1
votes
2
answers
59
views
Postgresql - user does not inherit table privileges
Here is my problem : I have created a role R1 that have all privileges on schema S1. I also have created two users U1, U2, with inherit, that both are members of R1. U1 has created a table in S1. Why ...
- 1
0
votes
0
answers
36
views
EKS:Create Cluster -- ClientException: You are not allowed to pass the role
EKS:Create Cluster -- ClientException: You are not allowed to pass the role
I'm facing an error when I create a resource with Tofu. I've checked all policies, and no one policy denied the request.
...
0
votes
1
answer
74
views
Problem: Managing Multiple Roles for Users in a Fullstack Project [closed]
I’m working on a fullstack project where I need to handle users with multiple roles. In my current setup, I have three main roles: client, recipient (destinataire), and administrator. The challenge I'...
-1
votes
1
answer
636
views
How to revoke warehouse priviledge for role in Snowflake
I am trying to run query while selecting role AP_KPO_ANL with warehouse OP_WH. But now i created another new warehouse and grant role access to this new warehouse.
Now i want to revoke access for ...
- 4,021
1
vote
1
answer
342
views
Flask Security Permissions of Roles
Flask Security offers a role system, a user can be assigned one or more roles. Similar to the login with @login_requiered, there is a @roles_required('Admin').
In Flask Security there are also ...
- 15
1
vote
2
answers
115
views
Which role is responsible for performing `ON UPDATE SET DEFAULT` in PostgreSQL
In PostgreSQL I create table A referencing table B by FK with constraint option ON DELETE UPDATE SET DEFAULT. If the referenced record from table B is deleted, the physical change of the original FK ...
- 394
1
vote
0
answers
297
views
Why one superuser cannot use GRANT in Postgres 16
Postgres 16 has user ingmar which is marked as superuser and has create role rights:
CREATE ROLE ingmar WITH
LOGIN
SUPERUSER
INHERIT
CREATEDB
CREATEROLE
NOREPLICATION
BYPASSRLS
...
- 28.2k
0
votes
1
answer
237
views
Manage role's resources in Entra ID - Azure Portal
I'm building a React web app, and I'd like to manage the role access with Entra ID.
In Entra ID you can add a new App Registration and into it, create App Roles to later assign to users (in App ...
1
vote
1
answer
72
views
Assign different permissions to multiple users having same role in C#, Asp.net boiler plate
I am using ASP.NET Boilerplate. I have defined a role named Customer and assigned many permissions to this role such as Create company and Delete company.
However, I want to give the user the ...
- 11
0
votes
1
answer
84
views
Two PUBLIC Views in Stored Procedure - One Succeeds, One Errors?
If user A creates a view and grants READ on it to PUBLIC.
SQL>create view A.a_public as select 3 id from dual;
View created.
SQL>select * from A.a_public;
ID
----------
3
SQL&...
- 550
0
votes
1
answer
175
views
Initializing roles in .NET 8 Blazor web app
I am trying to initialize roles for my Blazor app. This is my service that should create roles if they don't exist:
using Microsoft.AspNetCore.Identity;
namespace FoodApp.Services
{
public class ...
- 1
1
vote
1
answer
696
views
How to create a custom role with specific permissions in Airflow using AirflowSecurityManager or other?
I'm currently working on a project where I need to create custom roles with specific permissions in Apache Airflow. I have a dictionary that contains the role names and their corresponding permissions....
- 947
0
votes
0
answers
61
views
How to merge roles in Postgres?
In my database I have two distinct roles which have no special attributes and thus do not inherit. They act as (RBAC) permissions, and there are policies for each permission on multiple tables.
How ...
- 3,152
0
votes
1
answer
500
views
Manage Access to file shares Azure
I created a file share system with 9 file shares that go to different people.
I can't limit access or specify who should have access to what.
I've read a bunch of documentation, but I don't think I ...
- 1
0
votes
2
answers
417
views
How to check future ownership in Snowflake Database objects?
I'd like to understand the roles assigned future ownership of database objects in Snowflake. For instance, let's say I have a database called 'DB' and a role named 'Role_1,' which currently has ...
- 2,451
1
vote
0
answers
123
views
Access to S3 in root and child account through roles
We have a root AWS account and a child account for another application called prod.
I want to give IAM users Full S3 Access to all the buckets in both the root account and the prod account.
In order ...
- 519
1
vote
1
answer
719
views
Snowflake stored procedure, tasks and ownership
I have a task on Snowflake that calls a stored procedure. This stored procedure has been defined as executed by the caller. The task which runs the stored procedure, in turn, has been created with ...
- 309