Questions tagged [application-role]

Application Role in Databases, especially in MSSQL Server

An application role is a database principal that enables an application to run with its own, user-like permissions. You can use application roles to enable access to specific data to only those users who connect through a particular application.

19 questions
0
votes
1 answer

Insert into another database using trigger and application role

I am currently experiencing a problem with the implementation of a trigger on a SQL Server 2019 database server. I have a trigger in table A1 of the DB_A database, it should do an insert into table B1 of the DB_B database when data is inserted into…
DUBS
  • 1
0
votes
2 answers

Using Azure AD and Getting App Role in C# Windows Application

I have a requirement to authenticate user in client side and pass the token to server side application. server side application parse the token and based on the role it will return the result. so we have created C# windows application as client and…
PMC Karur
  • 125
  • 2
  • 3
  • 10
0
votes
2 answers

Is it possible to use AzMan for role based authorization on objects which are created at runtime?

Is it possible to use AzMan for role based authorization on objects which are created at runtime? If yes how can this be done? For Example: If an object of class "CustomAlert" is created at runtime, I am trying to see if I can have different rules…
Varma
  • 771
  • 1
  • 9
  • 19
-1
votes
1 answer

Changing user password using application role

I'm using SqlServer and the application role for my application, but I also have username in SqlServer. Is there any possibility to change user password when using the application role? When I'm trying to change user password I get an error, that I…
1
2