Questions tagged [authentication]
The process of identifying the party logging into a system.
303
questions
0
votes
0answers
6 views
Does MySQL 8 on Ubuntu 20.04 allow password authentication for root user?
Just installed MySQL on a new development server and ran into an issue where root access seems to be denied to all Linux users other than root, even if they use the correct password. Also MySQL root ...
0
votes
1answer
15 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 ...
0
votes
0answers
12 views
Does Aginity Pro support support temporary credentials, assume role and multi factor authentication for connections for AWS Redshift
I am looking at Aginity Pro for connections to our AWS Redshift cluster. I can't find out if it supports the following:
Assume role. Our IAM users are in a single account, and we assume roles in ...
0
votes
1answer
15 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 &...
0
votes
0answers
52 views
Could not find a login matching the name provided
SQL Server 2016
We had a user on several servers that had sys admin. As a new DBA, I was told by my director to remove the user and create a new one to run jobs and do server linking. I removed the ...
0
votes
2answers
55 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 ...
1
vote
1answer
92 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 ...
0
votes
0answers
44 views
SET PASSWORD vs ALTER USER
On a fresh MariaDB install (10.4.12) if I do
mariadb-admin password ...
or
SET PASSWORD = PASSWORD('...');
for a root user, that doesn't force me to use password to authenticate. But when I do:
...
0
votes
0answers
33 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 ...
0
votes
1answer
27 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 ...
1
vote
1answer
38 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 ...
0
votes
2answers
84 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 ...
0
votes
0answers
23 views
How to setup MongoDB replication using openssl keyfile
I am having 3 standalone Mongo servers. All the three had setup using keyFile
Security:
keyFile: /var/lib/mongo/mongodb.key
Now I tried to add these servers into replication set. So I had ...
-1
votes
1answer
48 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 ...
-1
votes
1answer
26 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”,...
0
votes
0answers
36 views
Maxscale PAM and native authentication
I created 2 mysql users on a MariaDB 10.3.20 server (Linux Debian Stretch):
simpleuser is a standard mysql user (native authentication)
pamuser is a mysql user using PAM authentication
GRANT ALL ...
0
votes
2answers
46 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.
0
votes
1answer
166 views
Different ways to log in to MariaDB
I'm trying to log in to a mariaDB database which is (at least the vendor of the product that it was installed for tells so) "protected" by SSL.
I tried several tools but none of them works fully.
...
4
votes
2answers
42 views
Restrict Postgres superusers to local only connections
I have a database with several users: foo, bar, and super. I was looking at pg_hba.conf to lock down access.
I'd like to allow foo and bar to be able to connect from any IP with password ...
0
votes
0answers
68 views
Oracle 11.2.0.1.0 showing “no matching authentication protocol”
I have installed the above oracle version (personal edition) for my developmental purpose. But when I try to login through sqlplus, always it throws me the error no matching authentication protocol.
...
0
votes
0answers
25 views
Radius Authentication failure for Postgresql 10.0
When I am trying to authenticate the Postgresql with Radius server...I am getting the follwoing message at the command line
root@ykan-vm01:~# psql -h 172.29.226.240 -U Tom
Password for user Tom:
...
0
votes
1answer
38 views
Why is MongoDB user with the only privilege as “find” able to insert and update collection?
I want my user to have only find action privilege on a specific collection. However, when I create the user with the privilege, restart the mongod server and run the mongo shell again with -u -p and --...
0
votes
0answers
25 views
Authentication failure in parent child SSIS packages
I'm troubleshooting an issue for our developers.
A web app using windows authentication calls a stored procedure that executes an SSIS package. The SSIS package uses an "Execute Package Task," to ...
0
votes
1answer
758 views
db2 expired password but cannot reset
Has anybody encountered this problem with a db2 server? I'm running a development database and connecting to the database gives me a password expired error. Trying to reset it will give me an invalid ...
0
votes
0answers
85 views
Postgresql 10: Ldap authentication failing
I configured the pg_hba.conf of Postgresql 10 with following
host Tom Tom XXX.XX.XXX.XX/32 ldap ldapserver=XX.XX.XXX.XX ldap ldapbasedn="ou=People,dc=example,dc=com" ldapbinddn="cn=Tom,ou=People,...
0
votes
0answers
15 views
LDAP Authentication failing on Postgres9.1
Can any one please suggest what need to be done to make the LDAP authentication work on PostgreSQL 9.1. I am getting the below message
invalid authentication method "ldap": not supported by this ...
0
votes
0answers
77 views
Can't login into MariaDB slave servers
I have set up a master and a slave for MariaDB using the Bitnami docker image. The replication seems going smoothly:
MariaDB [(none)]> show processlist;
+-----+-------------+--------------------+--...
0
votes
1answer
624 views
Access denied for user 'me'@'localhost' (using password: NO)
I am am trying to learn mysql 101. Doing so, I broke my ability to login as root.
At first I could simply connect to mysql by running
sudo mysql
In an attempt to alleviate a problem, I ...
0
votes
0answers
24 views
Cannot connect to SQL Server DB instance using inetegrated Security [duplicate]
We are on SQL Server 2012(SP4) 11.0.7001.0(X64) Standard Edition(64-bit)
In one of our production servers we cannot connect to the instance using Windows Authentication- getting this error:
"The ...
1
vote
2answers
648 views
Can I connect to the database as the user “dbo”?
If not, why?
During security audit we are being asked if the dbo login is interactive. My understanding is that the account is automatically created and managed by SQL server itself and is not ...
0
votes
2answers
29 views
Postgresql - roles without linux accounts?
Basic question:
what I'm reading describes how to create linux users in parallel with postgresql roles.
However, I don't see the value in creating any of these users in linux - I just want to create ...
2
votes
2answers
71 views
How to find out all the permissions that belong to a specific server/ database role in SQL Server? [duplicate]
I can separately query all the server or database level permissions, but I want to know other thing. What server role do the given permissions exactly belong to? For example I want to see all the ...
1
vote
0answers
26 views
How does Oracle authenticate a user?
I'm learning Oracle and below is my testing of starting up an Oracle instance and make the database available.
oracle:[~]$ sqlplus
SQL*Plus: Release 19.0.0.0.0 - Production on Mon Aug 5 09:29:30 ...
1
vote
1answer
472 views
Windows Login can't access SQL Server even with SYSADMIN role
I'm working on AD permissions and have removed my user account from the Domain Admins security group. Now I'm having difficult accessing my SQL Server database with my Windows login. The login is in ...
0
votes
1answer
265 views
Execute SSIS procedure from stored procedure using non-privileged SQL login
I have a web app running on a different server that uses a SQL based login (not a windows based login) to connect to the SQL server. That app is calling a stored procedure that is located in a ...
-3
votes
1answer
1k views
The login is from an untrusted domain and cannot be used with Windows authentication
I am facing this issue after trying to run a Windows application on sharing client side in a workgroup environment, while this application working on server machine fine.
0
votes
1answer
354 views
Postgresql 11 SSPI authentication failing
On windows 2016 in AD setup when I try to use SSPI with postgresql 11 and following settings :
pg_hba.conf:
host all all 127.0.0.1/32 sspi map=newmap #IP4
pg_ident.conf:
newmap ...
1
vote
1answer
61 views
Disallow superusers and single-user mode in POSTGRESQL
I have a doubt about superusers and single-user mode.
I want to restrict the access to a certain database, in a way that only those users which I gave privileges can see the structure of my database. ...
0
votes
1answer
66 views
differences in the authentication scheme - could it be because of Kerberos?
I am using this script to check the connections to my sql server:
select
C.client_net_address,
S.host_name,
c.session_id,
c.net_transport,
c.protocol_type,
c.auth_scheme,
s.program_name
from sys....
1
vote
0answers
77 views
Cross Domain log shipping not working
I know there are many blog posts similar to this, and I have read them all and as far as I can tell things are setup correctly, but I still get invalid username or password when kicking off the copy ...
1
vote
1answer
177 views
MySQL change user login from one plugin type to another
I'm in the process of testing MySQL 8.0.
I have set up a test database, and the first thing I want to do is import my user account from MySQL 5.7.
So to do this I run:
/*ON MySQL 5.7*/
SHOW CREATE ...
1
vote
1answer
207 views
How to identify a Windows Remote Desktop user by SQL Server session id?
In SQL Server I've got the session id of a process that is blocking other processes. Now I'd like to identify the specific user or machine that causes this blocking. The users are authenticating using ...
0
votes
1answer
32 views
Should i place Registered-Users Info in every table? to Restrict user access to his Own Data only
Database: Relational Database - MySQL
I am making a database with multiple tables. In order to see his data from tables, User will need to log in. I only need to display those information(through web-...
1
vote
1answer
3k views
can't update user password on Mongodb 4.0.5 (Use of SCRAM-SHA-256 requires undigested passwords)
I'm trying to update a password from a user, using changeUserPassword(), and I just receive the following message:
Error: Updating user failed: Use of SCRAM-SHA-256 requires undigested passwords
&...
10
votes
2answers
928 views
Locked my sa user out
So I was trying to change some settings in my Microsoft SQL Server Management Studio 2019. I change the login mode from mixed (Windows and SQL authentication) to only Windows and now I am not able to ...
1
vote
1answer
173 views
Question on Enabling Kerberos Authentication using SetSPN for Availability Listener alternative DNS name
We have Availability Group, and original DNS name that was given to AG Listener, is too long (something like longername-Listener-01.mydomain.com); Its hard for us to change original DNS name of ...
0
votes
2answers
68 views
ssms does not let me change to server authentication mode and I can not log in
I have been using SSMS and logging in through server authentication for a week now and yesterday when I tried to login it suddenly told me "no process on the other end of the pipe".
I researched ...
0
votes
0answers
466 views
Authintcation error 28000 + 18456
I have been trying to link my mssql database to Django. When I run the Django server I get the error below. For normal query (out of Django), it works fine, however, the Django doesnt even connect. ...
0
votes
1answer
68 views
SQL Server Authentication
I am able to access a database using the Windows Authentication method in DBeaver. However, when I switch to different account in Windows and I would like to access the datebase, I used SQL Server ...
0
votes
2answers
475 views
Attempting to backup to remote NAS but access is denied
I was attempting to use Ola Hallengren's scripts to backup to a remote NAS, but it was failing and not giving any direct errors, so I tried doing it manually using Server Management Studio and got the ...
