Questions tagged [authentication]
The process of identifying the party logging into a system.
0
votes
1answer
26 views
How to use mysql_plugin utility?
I tried to follow this official documentation to install unix_socket plugin using mysql_plugin utility but getting an error that
Cannot read plugin config file unix_socket. Bad format in plugin
...
0
votes
0answers
38 views
sys.login_token doesn't include particular windows groups while they can be listed by sys.database_principals
When I query
SELECT principal_id, name, [type]
FROM sys.login_token
I found some local windows groups were not there.
However, when I check by
SELECT principal_id, name, [type]
FROM sys....
0
votes
1answer
20 views
How to get Kerberos working against a named SQL Server instance in Power BI Report Server?
I have a Power BI Report Server working perfectly connecting to SQL Server machines with a default instance only. I can also connect to SSAS named instances with the proper SPNs and by allowing ...
0
votes
1answer
28 views
Percona PAM with AD authentication using SSSD
I have installed percona PAm plugin on my Percona server as shown below:
mysql> show plugins;
...
| auth_pam | ACTIVE | AUTHENTICATION | auth_pam.so | GPL |
| ...
1
vote
0answers
19 views
Which client authentication methods make sense when calling `initdb`?
Postgres offers many client authentication methods:
Trust Authentication
Password Authentication
GSSAPI Authentication
SSPI Authentication
Ident Authentication
Peer Authentication
LDAP Authentication
...
1
vote
2answers
40 views
How to Disable Windows Authentication in SQL Server
I would like to say that as per my Organization requirement they want to Disable Windows Authentication in SQL Server.
My Environment is as follows:-
1) Microsoft Azure
2) Windows Server 2016
3) ...
0
votes
1answer
53 views
Running loadjava with Windows authentication
I want to run following command under Windows with Oracle Database 12c installed:
loadjava -force -genmissing -r -user username/password@database -verbose core-1.7.jar
The problem is that I use ...
1
vote
1answer
50 views
How to verify if given user@host with 'password' exists in MySQL 8.0+?
I write sanity check script for an application. One of the tests is supposed to verify that a given user@host with 'password' exists in MySQL. I'm using simple native hash passwords. In MySQL5.7- ...
1
vote
1answer
92 views
Can the new “SCRAM-SHA-256” password authentication mechanism in Postgres 10 and later work with any JDBC drivers?
Postgres 10 added support for a new password authentication mechanism, Salted Challenge Response Authentication Mechanism (SCRAM-SHA-256, see RFC 7677). Discussed by Michael Paquier.
➥ Can this ...
0
votes
1answer
103 views
Can `listen_addresses` system configuration setting in Postgres stop pre-authentication exploits?
You can set various configuration parameters for Postgres by either editing the postgresql.conf file manually or by calling ALTER SYSTEM commands.
One of those config settings is listen_addresses. ...
1
vote
2answers
137 views
Can't change authentication mode from Windows to both SQL Server and Windows
As the title suggests I'm having problems changing the authentication mode from Windows to both SQL Server and Windows mode in version 12.0.2. I have tried right right-clicking the server, go to ...
0
votes
1answer
27 views
Integrated Authentication vs? [closed]
my coworker and I had a debate and I am looking for Reddit to resolve it! We have PHP web apps running on IIS and are looking to setup the security to the database using one approach:
-What would you ...
2
votes
0answers
36 views
Modeling Database to Support Sub-Users for Users [closed]
I'm having a hard time wrapping my head around how to best model my relational database. I want to be able to structure it in such a way that a User on my site can create Sub-Users that are able to ...
0
votes
2answers
26 views
Where is the cache for the MySQL caching_sha2_password auth plugin stored?
Where is the cache for the new default authentication plugin caching_sha2_password in MySQL 8 stored? I want to know for future reference how to clear it in case I ever run into any problems using it.
0
votes
1answer
39 views
ISO 27001 - resetting passwords for SQL Server accounts
We are implementing security changes in order to pass an ISO 27001 audit.
We are in the process of setting all domain accounts (user accounts, admin accounts, service accounts) to have their passwords ...
1
vote
1answer
70 views
Cannot add Network Service as User/Login
I want to setup ProGet on a 2016 server with SQL Express and IIS.
Both the service and IIS web runs under the Network Service user. None seem to be able to access the Database on a local SQL Express ...
0
votes
1answer
53 views
Authentication type differences in SQL Server
I want to know what is the difference between authentication types(NONE, WINDOWS, INSTANCE) in
sys.database_principals table.
I can't find clear explanation in documentation.
Thanks
2
votes
1answer
40 views
Where is authentication information saved in master?
When using SQL Server Authentication mode, I know that usernames and hashed passwords are saved in the master database. I wonder is there a way to retrieve that information? If yes, which tables ...
0
votes
0answers
326 views
Password for Oracle Database 18c user “system” [duplicate]
I recently upgraded from Oracle 12c to Oracle 18c. When using SQLPLUS in 12c I logged in using "*
username: system
password: mypassword
But when I try to login in 18c using same it shows ORA-...
2
votes
2answers
270 views
When setting up security for linked servers, what does the Impersonate checkbox do?
Question:
what does this checkbox do?
4
votes
1answer
381 views
Using host names in `pg_hba.conf`?
According to the PostgreSQL documentation:
A host name specification that starts with a dot (.) matches a suffix
of the actual host name. So .example.com would match foo.example.com
(but not ...
1
vote
1answer
565 views
org.postgresql.util.PSQLException: FATAL: Ident authentication failed for user [closed]
(Note: Massive edit since the question was asked.)
I'm setting up an Atlassian Confluence server and I'm stuck at point 5.4 of the instructions, where the Confluence connection to the database must ...
0
votes
1answer
659 views
The server principal “loginname” is not able to access the database “SSISDB” under the current security context
We have a stored procedure which calls an SSIS package from the SSISdb database.
It works when run as myself using my domain account, however the VB6 application which will call this connects to the ...
3
votes
1answer
8k views
What is mysql_native_password?
I was trying to set password for root. When I run:
mysql> SELECT * from mysql.user where User="root";
It shows:
+-----------+------+-------------+-------------+-------------+-------------+-------...
1
vote
1answer
162 views
Remote login via rman working for one instance but not another
I have Oracle 12c installed on two servers. On server UAT I have an instance RMCAT that hosts an RMAN recovery catalog. On server EXT I have two instances, extdev02 and extuat01. I can use the ...
1
vote
1answer
186 views
MySQL - admin user is able to change password of the super user
I am new to MySQL administration and hence this question - I wanted to create a MySQL admin user who wasn't the super-user. I assumed Amazon RDS MySQL community server will be a good template to work ...
2
votes
0answers
321 views
Unable to start Oracle Listener - “The user name or password is incorrect”
I am trying to install Oracle Database 12c on a Windows Server 2012 machine. The installation goes well for the most part, except that I get the error "Oracle Net Services configuration failed" (that ...
-2
votes
4answers
185 views
Windows authentification to SQL Server authentification
How to change login name from Windows authentification to SQL Server authentification?
3
votes
1answer
2k views
psql, I try to connect to a database and I get “psql: FATAL: Peer authentication failed for user ”, why?
I'm using psql (9.2.23) on my Dell Latitude 3540 laptop running Linux CentOS 7.
I want to do a simple thing: create a database username and log in as that username.
My operating system username is "...
2
votes
1answer
73 views
How do I enable md5 authentication for only one user?
I just installed Postgres 9.2 on CentOS 7. I want to keep peer authentication for all my users except one, which I would like to be able to access via "psql" through any user's account. I tried ...
1
vote
0answers
92 views
Best way forward for setting up Debian 9 / MariaDB (10.1.26-0+deb9u1) with root user Adminer access
I have a new Debian 9 LAMP server (includes MariaDB v10.1.26 rather than MySQL). I note that in this build, the debian-sys-maint user no longer exists. Instead a unix_socket is used to grant root user ...
2
votes
1answer
93 views
how to create ambari database backup without enter password
We configure the file .pgpass as follows in order to create database backups without entering a password:
-bash-4.2$ more .pgpass
localhost:5432:postgres:ambari:bigdata
-bash-4.2$ pwd
/var/lib/pgsql
-...
1
vote
1answer
143 views
pg_hba.conf entry query
I'm trying to formulate a rule from pg_hba.conf file. Thus far I have understood that pg_hba.conf file is used to give access to the specific user for a specific host. But I just want to take a second ...
0
votes
0answers
3k views
unable to start psql : no pg_hba.conf entry for host “::1” , user “postgres”, database “postgres”, SSL off
I am unable to connect using psql to PostgreSQL 9.6 on Windows 10. I saw almost all the StackExchange questions regarding this error. While installing Postgres it asked for superuser password and I ...
0
votes
2answers
55 views
Fail to login on Sql server with DNS but not with IP
I'm facing a strange problem :
I have a sql server on the IP 80.248.XXX.XXX
I've also create an Alias on SQL Server like servername.sql.mydomain.com with this tutorial :
https://www.mssqltips.com/...
0
votes
0answers
52 views
Permissions via Trusted Connection partially working
Issue on apparent partial permissions but cant pinpoint. I have SQL-Server that allows trusted connections for Windows Authenticated users. C#/WPF app connection no problem.
The database has some ...
2
votes
2answers
408 views
MongoDB Cluster - Can't access member of shard with credentials
I have a Sharded Cluster and I am trying to access a specific member of a replica set within a shard.
When connecting to the mongos it is fine, but when using the same credentials on a member of the ...
0
votes
0answers
77 views
How to make Oracle accept any password for login?
We have an old application which we need data and reports from. The application is configured to retrieve data from Oracle DB and the login username and password are hardcoded in the application. ...
3
votes
2answers
1k views
Add host to existing user @ Mysql with the same permission
I would like to add another host for existing users at my DB. I want this new record to have a same privileges with the existing user as well. I saw this thread https://stackoverflow.com/questions/...
4
votes
1answer
455 views
set Windows authentication for postgres
I'm trying to set Windows authentication for a postgres server.
The process is not well documented and makes the whole thing, obscure.
I found this doc but it is quite unclear.
In the necessary ...
1
vote
1answer
79 views
Sql servers are using Kerberros and NTLM Authentication [closed]
Lately I have been facing failed connection errors mainly due to servers using NTLM Authentication. In our environment the servers have a combination of ntlm and kerberoos. My question is If i ask my ...
1
vote
0answers
160 views
Why MS SQL Express cannot find my local Windows user?
First of all: My Images use german as a language, sorry for that but maybe you find the problem though.
So I am setting up a SQL Database on a MS SQL Server 2016 Express.
While doing so I am using ...
1
vote
0answers
40 views
SQL-Server for Linux WORKGROUP authentication handling
I installed SQL-Server for Linux on a linux Centos 7 distro, it works fine, but I need a workgroup authentication. It's required by the client (SAGE Ligne 100) which runs on a Windows workstation. ...
4
votes
1answer
2k views
SQL Server SSL Encryption - SelfSign Cert working - why?
I realize this is strange behaviour and I wonder if it is supposed to be working that way when using SQL Server generated self-signed certificate.
Client (Management Studio) with "encrypt connection" ...
1
vote
0answers
182 views
Error while connecting to PowerBi
I am trying to connect PowerBi to a local SQL Server instance.
It has previously worked with a direct Windows Authentication. I tried changing it to a SQL Server Authentication. No luck.
I have ...
1
vote
1answer
1k views
For how long postgres will keep alive connection after changing credentials?
I have an app running Ruby on Rails, standard nothing fancy at all. Today when I was changing password in Postgresql I spot that app is still running with old credentials. This gives me time to ...
0
votes
1answer
1k views
mongodb service won't start after adding admin user in ubuntu 16.04
I have an ubuntu 16.04 and I have installed mongodb on it yesterday with sudo aptitude install mongodb; it worked very well at start. I decided to add authentication info to mongodb, so I opened a ...
1
vote
1answer
95 views
MariaDB multiple auth modules for a user?
MariaDB has pluggable authentication, like PostgreSQL. Unlike PostgreSQL, I can't figure out how to support two forms of auth for a user. For instance, in PostgreSQL we can have the following in our ...
1
vote
1answer
535 views
Amazon RDS Database privileges question
I have created a database and have my username which is part of the rds_superuser group. I granted a friend access to my database and whenever he creates a new table I am unable to view his table and ...
5
votes
1answer
1k views
How to prevent a login from 'listing' a table or view definition in PostgreSQL?
Is there a way to prevent a login from listing the tables and columns in a schema?
I have to give access to a remote login to query on a single view; however, I also must make sure that such login ...
