2022 Developer Survey is open! Take survey.

Questions tagged [authentication]

The process of identifying the party logging into a system.

Filter by
Sorted by
Tagged with
-1 votes
1 answer
29 views

Creating a database with authentication enabled on mongodb

I can create a database using a specific role for my "user1". I have tested and a user "test1" can not create a database in the mode authorization enabled. How works the creation ...
user avatar
6 votes
2 answers
384 views

How to start MySQL after failure?

After I reboot my server, I can no longer start mysql. I have followed several solutions posted here: This This Or this Did not help much... :( I run the following commands to start the service: ...
user avatar
0 votes
2 answers
52 views

User handling in MS-SQL database

I have an MS-SQL installation, controlling different databases. This can be accessed using Microsoft SQL Server Management Studio 18. For doing that, I use Windows authentication. In there, I have ...
user avatar
  • 333
0 votes
2 answers
58 views

Store LDAP bind credentials in environment variables for pg_hba.conf

I am working on setting up LDAP authentication for a PostgreSQL database and have added the following in my pg_hba.conf file: # TYPE DATABASE USER ADDRESS METHOD host all all ...
user avatar
0 votes
0 answers
49 views

Is there a way for a SQL Server Login to gain permissions from multiple groups?

I have a security solution that I am trying to build. But I am unable to get it to a state that I am happy with. I am hoping someone will be able to shed some light on the correct path or deny the ...
user avatar
0 votes
1 answer
174 views

How to sync SQL Server Logins with database User after a restore from another server

I have a database server with several databases inside. This server is used as test server to store a set of test databases. The test databases do not come from the same production server thus I can ...
user avatar
0 votes
0 answers
57 views

Enable username and password authentication on mongodb sharded cluster

I have a mongodb cluster(1 mongos, mongo config replica set with 2 members, 1 shard with 3 members) and I have enabled internal authentication in config replica set. Also my backend code connects to ...
user avatar
0 votes
1 answer
687 views

PostgreSQL: Using the .pgpass file

I have been reading up on the .pgpass file, but I can’t get it working for me. My .pgpass file looks something like this: 127.0.0.1:5432:accounts:fred:p@55w0rd I set the privilege to 0600 (this is on ...
user avatar
  • 2,337
0 votes
1 answer
319 views

Authentication relying on mysql_native_password seems to also check for Linux user?

I have a mariaDB 10.3 install. The mysql.table states that 'root' login relies on mysql_native_password plugin, with no password set. If my linux user is root, I am able to connect to mysql using; ...
user avatar
0 votes
0 answers
47 views

Is it possible to use check_user_proxy on AWS RDS?

My top-level goal is to enable two-user (zero-downtime) secret rotation for RDS users. To recap/summarize the approach, you always have two accounts in your DB that have equivalent access. You switch ...
user avatar
0 votes
2 answers
50 views

Designating no password for account in MySQL config file

This is a theoretical question because having a DB account with no password is a terrible idea. Question: Is there a way to designate an account with no password in the MySQL config file?
user avatar
  • 235
1 vote
2 answers
132 views

DB2 Linux authentication fails

I have DB2 Express-C v10.5 instance configured to authenticate against LDAP. The LDAP sever is going to be shutdown and I should configure the same DB2 instance to use Linux authentication. I copied ...
user avatar
  • 111
0 votes
0 answers
74 views

Powershell connecting to Azure SQL DB errors out using Active Directory Password authentication

The following powershell script connects to an Azure SQL database using Active Directory Password authentication. Add-Type -Path ('C:\Program Files\PackageManagement\NuGet\Packages\Microsoft.Data....
user avatar
  • 11
1 vote
1 answer
728 views

Which authentication is better for MS-SQL Server 2019 : integrated security=SSPI vs uid=sa;pwd=xx | windows auth vs sa auth

In my different web applications I use both ways, however, I would like to learn which method is better: 1: server=localhost;database=x; integrated security=SSPI;persist security info=False; ...
user avatar
0 votes
1 answer
618 views

Does my PostgreSQL instance support kerberos/gssapi authentication?

I installed it following instructions from digital ocean how-to-install-postgresql-on-ubuntu-20-04-quickstart: % sudo apt install postgresql postgresql-contrib I also did a 'show all' in psql and ...
user avatar
  • 111
1 vote
1 answer
665 views

Nested AD group access not working when nested more than 2 levels deep?

For the setup of the security of the databases we have created a number of nested Active Directory groups: Group Members Group type RGP-EA_PROD-RW RGP-SparxEA-RW Domain Local Security RGP-SparxEA-...
user avatar
1 vote
1 answer
142 views

PostgreSQL keeps asking for user password with "trust" authentication enabled

I created a user john with createuser and didn't supply any passwords for it, i.e. no -P option specified. I then proceeded to add the following line above all other lines in the pg_hba.conf file: ...
user avatar
1 vote
0 answers
28 views

Saving multiple authentication strategies to the same database

I need some advice with the logic behind this authentication method. I'd like my app to have multiple ways to create accounts: email/pass twitter google I can handle the email and password login ...
user avatar
1 vote
1 answer
233 views

Kerberos Issue - Anonymous Login

I have a linked server that connects one SQL Server to another SQL Server. For two weeks now there has been an error when testing the connection; Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. ...
user avatar
1 vote
1 answer
179 views

Can SQL Server OpenQuery/OpenRowSet to an LDAP Linked Server be used for Authentication?

I can fetch data back from LDAPS (port 636/3269) by first creating a Linked Server using sp_addlinkedserver and sp_addlinkedsrvlogin. However, what I really need to do is to authenticate a Username/...
user avatar
0 votes
1 answer
510 views

PostgreSQL Linux PAM Authentication Error

I'm using PSQL version 12.5 on Ubuntu 20.04.1. My pg_hba.conf file looks like this: # DO NOT DISABLE! # If you change this first entry you will need to make sure that the # database superuser can ...
user avatar
0 votes
1 answer
617 views

Active Directory authentication with SQL Server on Linux containers

I have a problem and hope someone can help me. I have SQL Server as docker container. I want our developers able to login in SSMS (SQL Server Management Studio) using their Active Directory users. I ...
user avatar
0 votes
1 answer
1k views

Why do I have to set MySQL user password with mysql_native_password to connect with Workbench?

I've noticed if I set the mysql user's password like below, I cannot connect with MySQL Workbench. ALTER USER 'root'@'localhost' IDENTIFIED BY 'myPassword' If I use this below I can connect to it: ...
user avatar
-1 votes
1 answer
40 views

How to prevent starting of MongoDb 3.0.3 instance without "--auth" parameter?

I have a local Mongo database for which I have created users and authenticating through my code. But the authentication is only valid if mongo instance is run with "--auth" parameter. If ...
user avatar
-1 votes
1 answer
324 views

Best practice for connecting to Postgres from Django [closed]

I recently installed Postgres 11 on my Raspberry Pi 4, and attempted to connect to a database from my Django app: return psycopg2.connect(dbname="covid") The connection failed like so: ...
user avatar
  • 109
0 votes
1 answer
76 views

Snowflake: how to allow only Key Pair Authentication connections?

Is there any way to configure Snowflake to allow only key pair authenticated users' connections? At the moment you can add RSA_PUBLIC_KEY_FP to any user. But he can connect easily without specifying ...
user avatar
0 votes
0 answers
30 views

Oracle DB Authentication Prioritization

If an Oracle authentication service has been configured, such as SecurID, does this mean that local users using Username/Password cannot use these credentials to login? From this link it appears as ...
user avatar
  • 1
0 votes
0 answers
36 views

Can't connect to postgresql database with SSL using GSSAPI

With postgresql 12.4, I've got this in pg_hba.conf: hostssl all all 192.168.0.0 255.255.0.0 gss map=myrealm but whenever I try to connect with: psql 'postgresql://hostname/database?sslmode=require' ...
user avatar
  • 101
1 vote
1 answer
550 views

Disable password policy for partially-contained database

I'm stuck in a situation where I need to create a new user for a partially-contained database (SQL Server 2016). The password is short, so I get an error: Password validation failed. The password ...
user avatar
  • 13
0 votes
1 answer
2k views

Connect DBeaver to PostgreSQL 13

I've been using PostgreSQL 10 and 12 on Windows successfully with DBeaver in the past. Now I've set up a new development machine and installed the current PostgreSQL 13.0.1 and the current DBeaver 7.2....
user avatar
  • 193
0 votes
1 answer
308 views

How can I add a user and specify a password for a in IBM Data Studio? [duplicate]

In Data Studio I can connect to a sever/database, go down to Users And Groups, right-click on Users and add a new one. But the program never asks me for a password. How can I specify it? Also, no ...
user avatar
0 votes
1 answer
25 views

How to know if mysql server is using sha_256 or caching_sha_256 authentication plugin?

Seems like I am using an older version on Mysql Server which uses sha_256 plugin for Authentication (which is now deprecated) .Because of this, I am unable to connect to my server with third party ...
user avatar
  • 101
0 votes
1 answer
70 views

Enabling TLS and TLS-MA simultaneously for different clients of a Oracle DB

We have a requirement where we want to enable TLS-MA for some of the clients connecting to a specific Oracle database while the other clients can continue to use TLS with server certificate. We are ...
user avatar
0 votes
0 answers
647 views

Bash Script Can't Connect to Azure Postgres using ENV Vars - "The Username should be in <username@hostname> format"

I have a bash script that exports ENV vars to use in connecting to an Azure Postgres DB (mydb.postgres.database.azure.com). For the user portion of that specifically it looks like this: export PGUSER=&...
user avatar
  • 137
0 votes
1 answer
507 views

pgBouncer - multiple servers with same username but different password

I have an active pgBouncer setup with one PostgreSQL server. We are planning to add one more PostgreSQL server to the same pgBouncer. But the problem is that both databases servers have the same ...
user avatar
  • 1,688
1 vote
0 answers
58 views

Why is the authentication_string different from the other one if the passwords are the same?

I've set the same passwords for the following accounts: 'root'@'%', 'root'@'127.0.0.1'. When I type select user, host, authentication_string from mysql.user I get different values for the ...
user avatar
0 votes
2 answers
2k views

Power BI report server: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON' when trying to view a report

We have SQL Server 2019 and Power BI Report Server installed on the same host. we're using a virtual service account for Power BI Report Server. We get the following error when trying to view a report:...
user avatar
  • 1
4 votes
1 answer
97 views

Active Directory Name Change

Our Active directory will change the accounts name for example John Doe Jdoe@abcd.com to John.Doe@abcd.com. My question is do I need to change all the SQL Logins individually or the person can login ...
user avatar
  • 1,007
0 votes
1 answer
67 views

How to efficiently combine user authentication with token authentication?

What is the most efficient approach of authentication, considering an user based authentication system combined with a token based authentication system? For this question please consider the ...
user avatar
0 votes
1 answer
572 views

How to use BCP Utility queryout in a network path with crededential (login required) for SQL Server

I'm having a hard time figuring out on how can I export my selected table in a network path that requires login credentials. 'bcp "select ''StudentName'' UNION ALL SELECT StudentName AS ...
user avatar
2 votes
1 answer
2k views

On-premesis SQL Server setup for MFA against Azure AD

I am trying to set up multi-factor authentication in SSMS using an on-premesis SQL Server (Standard Edition). I believe the SSMS is simple enough. Under the "Login" tab, I have chosen &...
user avatar
  • 45
0 votes
2 answers
898 views

Connect to a local PostgreSQL server using peer auth with pgAdmin

Context I have a PostgreSQL server running on a remote machine, but I'm connected locally through VPN. Its pg_hba.conf file is accepting peer auth for local connections; local all ...
user avatar
  • 216
2 votes
1 answer
3k views

MS SQL Login without password

I need to login to MS Sql from ODBC to my MS Sql instance on Linux server. Following are my question Is there a way to do it without Active Directory (maybe with LDAP or ADLDS if it does not change ...
user avatar
  • 23
0 votes
0 answers
116 views

MongoDB cluster use x509 for internal authentication only

I'm setting up a sharded cluster. I've enabled TLS and added certificates to each server in my shards/config replica sets and also my mongos instance. But is it still possible to connect to the mongos ...
user avatar
  • 113
0 votes
1 answer
41 views

Why do databases in mongodb have roles?

I have read about mongodb role based access control and I have understood it to a large extent. I was going through this tutorial and when you run show roles on the mongo shell it returns a different ...
user avatar
  • 127
1 vote
1 answer
40 views

What are the real life uses of role based authentication control in a database? [closed]

I am new to database management. I was going through the mongodb docs for Role Based Authentication Control. I have understood how it works, but I have a few questions. How is it applied in real life ...
user avatar
  • 127
0 votes
2 answers
509 views

Deny a Sql Server user from a specific hostname

Is it possible to block a sql server user not to execute DDL and DML operations from a specific hostname (client)? I have a CRM web application. That app connects to my database with a sql server ...
user avatar
  • 59
-1 votes
1 answer
53 views

Login failed for user 'sa' State: 8, in short time

I have setup SQL Server on server Customer. Recently, log files in SQL Server increase continuously. I checked the content of those logs - see here: In my application I use an account for connecting ...
user avatar
-1 votes
1 answer
125 views

PostgreSQL Password Authentication Error...but cannot find account

I'm getting the following error within the PostgreSQL log file. When an external service is calling the DB for map routing, the following error appears. However, within “Login/Group Roles”,...
user avatar
0 votes
2 answers
2k views

How can I find out if a user's password has expired in MySQL?

How can I find out if a user's password has expired in MySQL? The MySQL version I'm using is 8.0.16.
user avatar

1
2 3 4 5
7