All Questions
Tagged with users authentication
13 questions
0
votes
0
answers
100
views
connection failed: FATAL: role "y" does not exist when .ini has role "x"
I have a Python program for PostgreSQL database management. Today it started throwing
psycopg.OperationalError: connection failed: FATAL: role "role_a" does not exist
Connection parameters ...
- 133
0
votes
2
answers
7k
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.
- 21
2
votes
2
answers
2k
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 ...
5
votes
3
answers
4k
views
Who is the person using a SQL login?
Is it possible to find out who used a SQL-Server login?
Let's assume we suspect a person to abuse a SQL login that is supposed to be used by an application only to logon to SQL-Server. Is the domain ...
- 4,807
2
votes
0
answers
738
views
How do I authenticate a Database User by a LDAP Server and then to login with the SQL Developer, without using the OID/Apex?
I want to create a global User, identified by a LDAP_DN.
My Problem is: I can automatically create users, but when I try to log on to the database, I get the error message that the login data are ...
- 21
2
votes
1
answer
2k
views
Best way to remap database login to new database user and keep previous database user
Here's what my environment looks like:
Active Directory (mydomain.local)
- Groups
- group01
- Members
- aduser01
SQL Instance
- Logins
- mydomain\group01
- ...
- 175
1
vote
3
answers
5k
views
Mapping a Login to a User
On my production system I login to SQL Server with CPSDOM\mconnors. When I execute SELECT CURRENT_USER; it returns CPSDOM\mconnors.
We use Windows authentication on our DBs.
On my test system I ...
- 141
0
votes
1
answer
526
views
How to set up an SQL Server authentication login for a database instead of using Windows Authentication
Not sure what I am doing wrong so I have included the parameters I used which I used the existing login and this article for reference:
http://itproguru.com/expert/2014/09/how-to-fix-login-failed-for-...
- 131
1
vote
1
answer
864
views
Please explain SYSCS_UTIL.SYSCS_CREATE_USER() function
Can someone please explain to me how SYSCS_UTIL.SYSCS_CREATE_USER() works? I tried adding a new user like this: SYSCS_UTIL.SYSCS_CREATE_USER('user', 'someP@ss'), and it gave an exception Error code ...
- 111
1
vote
1
answer
799
views
db2 connecting to a db via alias and storing user name and password
I created a TCP node and I catalogued a db into it. The catalogued db needs user name and password to be accessed. Is there anyway I can store username and password in the cataologue (or other way)? I ...
1
vote
1
answer
1k
views
SymmetricDS fails to start for PostgreSQL 9.2
I'm trying to get SymmetricDS up and running with PostgreSQL.
I've followed the tutorial (almost) exactly.
(I have not set up a separate node yet since, for my purposes, I need that separate node to ...
- 207
3
votes
0
answers
1k
views
How to set up users in SQL Server 2008 Express over workgroup? (no domain)
The situation is this: simple network, one server not a domain controller, running SQL Server 2008 Express (64bit). 8 workstations running windows 7 pro connected to it. Last week after Windows ...
31
votes
7
answers
195k
views
Access denied for user 'root'@'%'
I used to access the root user in MySQL just fine. But recently, I am no longer able to.
I am able to login fine :
mysql -u root -p
Here is the mysql status after login :
mysql> status
-------...
jules testard