Skip to main content

Questions tagged [database-user]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
0 answers
180 views

How to add logout button IN SSRS web page?

I have such question. Is it possible to add logout functionality for current user IN SSRS web page in browser?
Robert Margaryan's user avatar
0 votes
1 answer
40 views

Postgresql - Create role to connect to database and revoke all other permissions

I have an application which is configured with the multitenancy strategy of "single database multi schema". Now I want to create a role which can have only specific permission that is to : ...
Subhajit's user avatar
  • 101
0 votes
0 answers
77 views

Sql server database restoring from backup, sql users without login

After restoring a database from another SQL server, set database comes with database users without login. Do these users have any actual functionality or they are practically dead users? I've looked ...
Peter's user avatar
  • 79
0 votes
0 answers
160 views

Assigning new role to already existing user in RDS

"We have an RDS instance hosted for Aurora PostgreSQL, specifically using the 'db.r5.xlarge' instance type. When we initially set up the RDS instance, a default user named 'rdsadmin' was ...
Naresh Barule's user avatar
0 votes
1 answer
329 views

SQL Server 2012 how to audit user's access to database tables and views?

We have a read-only login account that unfortunately was created without proper planning, and now users throughout the company are using this login to access tables and views in our database. The ...
Fandango68's user avatar
0 votes
1 answer
227 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 ...
JOE_JOE's user avatar
0 votes
1 answer
697 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'...
Jim's user avatar
  • 103
0 votes
1 answer
1k 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 ...
Hrvoje T's user avatar
  • 163
2 votes
1 answer
1k 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 ...
SqlWorldWide's user avatar
  • 13.5k
0 votes
2 answers
148 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), ...
sitems's user avatar
  • 103
0 votes
2 answers
206 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 ...
Dominique's user avatar
  • 581
0 votes
0 answers
253 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 ...
Rob's user avatar
  • 101
3 votes
3 answers
9k 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 ...
PTL_SQL's user avatar
  • 341
3 votes
1 answer
8k 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 ...
Sajid Maqsood's user avatar
0 votes
2 answers
582 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:\"...
Megidd's user avatar
  • 99
1 vote
1 answer
89 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 ...
Danish's user avatar
  • 11
0 votes
1 answer
79 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 ...
febry's user avatar
  • 57
1 vote
1 answer
4k views

UserNotFound mongodb error

I know there are lot of articles with the same issue and I explored every other article trying everything and still this error persists. Here are the steps I followed: use admin. created an admin ...
Akshay Gupta's user avatar
2 votes
1 answer
467 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 ...
pascatl's user avatar
  • 123
0 votes
1 answer
218 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://...
Beth Lang's user avatar
  • 952
2 votes
1 answer
107 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 ...
xof's user avatar
  • 25
0 votes
0 answers
223 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 ...
Aleksey Vitsko's user avatar