Showing results for 
Search instead for 
Did you mean: 

Best Practices for Database User Access


Hello, what is considered the best way to handle logins to the Incorta Postgres database (from a DB tool or from Power BI)?  

We have SSO configured for our online access, and we use generic IDs for people to access the database.  Is there a way to allow an individual user to log in to the DB without a specific login and password?  I'm thinking of how Windows Authentication works with Active Directory.

We can't easily setup a 2nd individual user account for everyone because their emails are already being used by the 'User' setup via the SSO process.  

So far, sharing generic IDs and passwords is our solution, but we'd like a better way that doesn't involve sharing IDs and passwords.