3,451 questions
1
vote
1
answer
91
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,156
0
votes
1
answer
81
views
Laratrust role not updating until php artisan optimize:clear
I’m using Laravel 11 with Laratrust v8.3, and I’ve noticed something strange on my production server.
When I assign or update a user’s role, it doesn’t take effect immediately — the user still has the ...
1
vote
1
answer
62
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
0
votes
0
answers
61
views
Openstack Kolla custom domain admin role
I am busy testing out openstack using the kolla-ansible deployment, version 2025.1. I want to use multi-domain which I have enabled and that works. I then wanted to try creating a user in a domain ...
- 113
1
vote
2
answers
108
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
122
views
Azure won't show roleDefinition for directory roles
I'm using the following API, it works with regular roles such as "Reader":"acdd72a7-3385-48ef-bd42-f606fba81ae7".
az rest --method get --url 'https://management.azure.com/providers/...
- 305
1
vote
1
answer
42
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
...
0
votes
0
answers
52
views
Http Error 401 Error Contact the Site Owner [duplicate]
I am shown the error: This page isn’t working right now If the problem continues, contact the site owner. HTTP ERROR 401 in my Asp.Net Core Application. I am using JWT Authentication in my Asp.Net ...
- 1,305
1
vote
1
answer
88
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
1
answer
40
views
Unexpected Redirect to /home in Laravel Multi-Guard Auth - Route Not Working (302)
I'm facing an issue with my multi-guard authentication setup in Laravel involving impersonation. I have four guards defined: admin, distributor, customer, and user. My system allows a customer to ...
0
votes
0
answers
122
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/...
1
vote
1
answer
121
views
User's role switches to "None" from "Administrator" on login [closed]
Whenever some users (but not others) log into a WordPress website, their role changes from "Administrator" to "None". Their first name, last name, and nickname also get set to ...
- 311
0
votes
1
answer
368
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
0
votes
0
answers
105
views
Role definition in powerbi using TMDL
I am getting and error when defining a new role in powerbi using TMDL:
createOrReplace
role roleName
modelPermission: read
member userName
memberId: '203'
...
-1
votes
1
answer
100
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
0
votes
0
answers
47
views
Should security roles ever negate or remove functionality or should they be additive only?
In my experience I believe that security roles in a software system where:
A user can have multiple roles and...
Roles can be included in groups (where groups are assigned to users)
...should only ...
- 1,648
-1
votes
2
answers
65
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
1
answer
200
views
Permissions required to add and remove servers from Azure maintenance configuration
We use maintenance configurations as part of our Azure update manager configuration. For Azure VM's is there any role other than granting contributor role permission to the azure subscription that ...
1
vote
1
answer
59
views
@RolesAllowed in Apache CXF
I'm trying to migrate a JAX-RS application from Jersey to Apache CXF. I'm not using Spring, so I'm trying to configure it by extending javax.ws.rs.core.Application.
I also implemented
public class ...
- 21.5k
0
votes
1
answer
79
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'...
0
votes
1
answer
163
views
I'm unable to add role assignments
I don't know how to solve this:
The client 'live.com#[email protected]' with object id 'xxxxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx' does not have authorization to perform action 'Microsoft.Authorization/...
-1
votes
1
answer
646
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,011
1
vote
1
answer
187
views
How to create Postgres role that is not "on" by default
I'm trying to create a role that is not "on" by default but needs to "turn on" by SET ROLE command. I thought NOINHERIT would be the thing but this is not working (in Postgres v. ...
- 981
1
vote
1
answer
349
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
0
votes
1
answer
115
views
In Azure AD B2C, is it possible to edit the User's (Custom) Attribute on the Azure Portal?
Here is my scenario:
I have a Portal service where User's can create account. Their default 'Role' is User. In my portal, I have an Admin portal that allows Admin Users to create other Admin Users (...
- 183
1
vote
2
answers
117
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
0
votes
1
answer
394
views
ASP.NET Core 8 + Keycloak: Role-based Authorization for Derived Controllers without Code Duplication
I'm working with ASP.NET Core 8 and Keycloak (version 24) for authentication and role-based access control.
Scenario: I have a base controller that implements basic CRUD operations for multiple object ...
- 25
1
vote
0
answers
301
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.3k
0
votes
2
answers
133
views
Translating a custom user role name in WordPress
I created a custom user role in WordPress:
add_role('warehouse', 'Warehouse', get_role('administrator')->capabilities);
How to add translations for the role name so that it shows up in admin ...
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 ...
0
votes
0
answers
72
views
Introducing custom-role in my Django based E-commerce application
I completed finish my Django E-commerce web-application. And now I want to add the facility of customer roles(admin,staff,merchant,customer). I'm having problems configuring this with my project. I'd ...
1
vote
1
answer
73
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
233
views
How to pass context from a command to the callback in discord.py
Partially Finished Product
So, essentially, I am trying to create a discord bot that will allow a staff member to request a role. That request will then be sent to an admin-only text channel with a ...
- 13
0
votes
1
answer
88
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
380
views
Problems with urls at Laravel 11
I have been having problems for a few days regarding access to routes defined for my middlewares. The specific problem with all this is that when, for example, I want to enter a URL of my entity other ...
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
0
votes
2
answers
302
views
roleDefinitions for Bing resource
I want to grant AppService access to a Bing resource (Microsoft.Bing/accounts@2020-06-10).
Which role (Microsoft.Authorization/roleDefinitions) should I set in Bing's IAM (Microsoft.Authorization/...
1
vote
1
answer
714
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
-1
votes
2
answers
1k
views
Can't drop role due to dependencies
I'm new to Postgres, and I want to delete a role named rp_ts04, but it complains about dependencies. I don't know how to check for these dependencies.
I've checked information_schema but it doesn't ...
- 511
0
votes
0
answers
62
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,156
-4
votes
1
answer
30
views
Hide Specific Div class for Specific User Role
I'm looking for a function that can hide the div class #header_aside from all users that are 'Employer'. Is someone able to help me with that? I tried a few different functions online but they haven't ...
0
votes
1
answer
511
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
1
answer
71
views
Snowflake SQL to Create Roles and SQL Statements. , facing unexpected <EOF> or unexpected 'END'
We intend to dynamically create roles based on SF metadata. Preferably through a Stored Procedure.
However, we are struggling to debug and spend way too much time investigating error codes that SF ...
0
votes
2
answers
422
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
0
votes
1
answer
98
views
How do I know a function is a service role?
When adding a service role to a user for example: AccessAnalyzerServiceRolePolicy, I am getting the error:
Failed to add permissions to davidh38
Failed to add AccessAnalyzerServiceRolePolicy to user. ...
- 3,153
1
vote
0
answers
126
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
0
votes
1
answer
381
views
Assigning manage-users role to confidential client with Keycloak
I've been trying to assign some management roles to the service account of a confidential client that I've set up, however it seems like I've probably set up my call wrong, since I'm getting a 404 ...
1
vote
1
answer
723
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
0
votes
2
answers
434
views
Ansible role variable is not defined
I can't user defined variable in ansible role
for example vars/main.yaml
---
hub:
app_disk: sdb
size: 40
vg_name: vg1
And I've tried to refer to that variable in tasks as :
- name: debug ...
- 1
1
vote
1
answer
277
views
Hierarchical roles for a user, with child roles having different permissions on case based, Laravel Spatie
In the application I am trying to build, I have two portals one for Admins and one for Users. As in a normal case scenario, I might have different Roles for the Admin portal, i.e., Super Admin, Admin, ...
- 13