Questions tagged [database-user]
The database-user tag has no summary.
20 questions
2
votes
1
answer
278
views
Have multiple users for your DB per action?
I installed my mariaDB and phpMyAdmin. I created a new user with all the Grand and Super priveleges. And I deleted the "root" user for savety.
Perfect.
As I follow an article: make a ...
- 43
0
votes
0
answers
676
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?
0
votes
1
answer
111
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 :
...
- 101
0
votes
0
answers
150
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 ...
- 79
0
votes
1
answer
945
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 ...
- 295
0
votes
1
answer
525
views
How do I restore a SQL Server backup to a different server that will synchronize the users correctly? [duplicate]
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
1k
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
2k
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 ...
- 163
2
votes
1
answer
2k
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 ...
- 13.7k
0
votes
2
answers
196
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
314
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 ...
- 629
0
votes
0
answers
516
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
3
votes
3
answers
11k
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 ...
- 449
3
votes
1
answer
9k
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
2
answers
764
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:\"...
- 99