Questions tagged [database-user]
The database-user tag has no usage guidance.
21
questions
3
votes
1
answer
4k
views
Why am I not able to add a user?
I'm running command grant all privileges on *.* to 'username'@localhost identified by 'strong password';, but I get the error:
ERROR 1064 (42000): You have an error in your SQL syntax; check the ...
2
votes
3
answers
3k
views
how to script out database users and permissions in all user databases in the instance [closed]
Can anyone help, please?
I would like to use Steve Kusen's script at Script DB Level Permissions v4.3
to loop through all the user databases automatically, using Aaron Bertrand's sp_ineachdb. Has ...
- 237
2
votes
1
answer
278
views
Function accepts only certain passwords in postgreSQL
I have created a function in a postgreSQL(v10.10) database to create new users or update existing ones.
As parameters you pass the username, password, role memberships, first name and last name. In my ...
- 123
2
votes
1
answer
478
views
Azure SQL Database - contained users password
Where is the password saved when creating a contained user for the Azure SQL database (PaaS)?
For example:
CREATE USER taiobtest WITH password='PVHz3U4A$LNytQF^';
GO
For server logins I can get it ...
- 12.6k
2
votes
1
answer
35
views
basic question about user-/role concept in postgres-databases
I hope this question is specific enough to be allowed and not doomed as opinion-based:
I'm fairly new at administrating postgres databases. My basic approach was to create a new user / role for each ...
- 25
1
vote
1
answer
44
views
Lost admin user ; Update not allowed on current user in MySQL
I work on MySQL. For making my database more secure I created new user and than deleted 'root' user which had all privileges. I think I did not give full privileges to new user. That's why it is ...
- 11
0
votes
2
answers
70
views
What can malicious postgres db user do to a linux server?
Suppose I created a db user with
create role myuser login password 'xyz';
and allowed typical read and write db permissions.
If a malicious user finds these login credentials (and has access to db), ...
- 103
0
votes
1
answer
507
views
How to allow remote MSSQL user to bulk insert my local txt file?
I have a txt file on my local PC. I run localy Java app which connects to remote MSSQL. Now I need to bulk insert from that text file into my database table.
However, SQL login can't read my file. I ...
- 133
0
votes
1
answer
86
views
Unable to change password in postgres even though I'm logged in as that user [duplicate]
Postgres running in RDS accessible only through an EKS cluster...
thus I have a (generic) pod in our cluster which allows me to access our postgres instance. I need to alter the password of the role I'...
- 103
0
votes
2
answers
98
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 ...
- 497
0
votes
1
answer
34
views
How do I restore a SQL Server backup to a different server that will synchronize the users correctly?
The issue I am having is I have 2 servers A and B. On A I have a dB, say it's called "MyDB"... On server B there are 2 dBs called "MyDB_Dev" and "MyDB_Test". These all ...
- 1
0
votes
1
answer
172
views
Using Azure MSSQL "contained database" how do you force a user to reset their password?
I'm setting up new users in an Azure MSSQL Contained Database.
I want new users to be forced to reset their password on the first login.
I see the ability to set a new password documented https://...
- 952
0
votes
0
answers
14
views
How to change password expire duration in the alter user statement in Oracle?
I'm working with a 19c Oracle database. We usually reset passwords for users and set temporary ones by using the password expire option with the alter user statement. The issue I'm going through is ...
0
votes
0
answers
22
views
Syncronizing logins between postgres and ms sql server
We have a setup where we have a "master" MS SQL Server database server which holds lots of (spatial) data. We are a windows shop, so we have Active Directory and it's user/group system.
For ...
- 567
0
votes
0
answers
82
views
How to retrieve user_name with user_id when this user is not on the current database
I'm using this query to get informations about locked sessions :
SELECT blocking_session_id AS 'Blocker'
,session_id AS 'Blocked'
,start_time
,status
,command
,...
- 1
0
votes
0
answers
21
views
User problem after recover redo log files
Hi I have the following errors one of the users does not work the deletion nor the database queries do not work in the schema:
----- Incident Context Dump -----
Address: 0x7fc4b0633b48
Incident ID: ...
- 228
0
votes
0
answers
75
views
Unable to drop a user in AWS Redshift
I want to drop user foo from an AWS Redshift db
DROP USER foo;
ERROR: user "foo" cannot be dropped because some objects depend on it
DETAIL: 1 object in database bar
1 object in database ...
- 181
0
votes
0
answers
85
views
Remote Login Failure for User - Error No 18456
I setup a test user in a SQL Instance.
I tested logging in from within the Windows Server and it worked fine. So password is fine and permissions are fine.
From my PC I attempted to connect to SQL ...
- 101
0
votes
1
answer
293
views
Equivalent Linux commands for Windows ones to create user and database
There is a manual for configuring PostgreSQL on Windows with these commands:
C:\"Program Files"\PostgreSQL\12\bin\createuser.exe --username=postgres --superuser --pwprompt saleor
C:\"...
- 101
0
votes
1
answer
35
views
Trigger Definer Already Same But User Still Denied
currently I already have user like this 'app_user'@'10.148.0.0/255.255.240.0'
and I have the trigger with definer like this
CREATE DEFINER=`app_user`@`10.148.0.0/255.255.240.0` TRIGGER ...
- 47
0
votes
0
answers
128
views
SQL Server - How to know to which database user certificate is mapped to?
Inside a user database, I have two certificates, both are used for signing stored procedures
First cert was created long time ago by someone
Second I created myself for testing purposes
For ...
- 5,034