question

RandRand-8344 avatar image
0 Votes"
RandRand-8344 asked GeethaThatipatri-MSFT edited

AAD on Posgresql

Hello, I am wondering if a user is authenticated in the Active Directory and is a part of a group lets say reader and that matches with a role reader in Postgresql to distinguish him. For example Jess authenticates in the Active Directory and executes a query on the Postresql is there a way to know that this is Jess authenticated or it would just show as reader in the logs?

Thank you

azure-active-directoryazure-database-postgresql
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

GeethaThatipatri-MSFT avatar image
0 Votes"
GeethaThatipatri-MSFT answered GeethaThatipatri-MSFT edited

Hi, @RandRand-8344 Welcome to Microsoft Q&A, Thanks for Posting your query.

As we understand the ask here is you want to know if there is a way to know the authenticated user executed query information.
Yes, all the logins are registered in the logs.

You can find the document for reference here for flexible

Please let us know if the information helps or do you need any other information.

Regards
Geetha


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.