Questions tagged [database-user]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
0 answers
20 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: ...
0 votes
1 answer
52 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
1 answer
407 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
2 votes
1 answer
421 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.5k
0 votes
0 answers
65 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
2 answers
55 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
2 answers
82 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 ...
  • 493
0 votes
0 answers
74 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
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 ...
  • 233
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 ...
0 votes
1 answer
258 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:\"...
1 vote
1 answer
40 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
1 answer
33 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
2 votes
1 answer
263 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
0 votes
1 answer
169 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
2 votes
1 answer
33 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
0 votes
0 answers
119 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 ...