Questions tagged [database-user]
20 questions
3
votes
3 answers
how to script out database users and permissions in all user databases in the instance
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 anyone got this to work? Kindly advise on how to do…
PTL_SQL
- 405
- 4
- 11
- 27
3
votes
1 answer
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 manual that corresponds to your MySQL server version…
Sajid Maqsood
- 39
- 1
- 3
3
votes
1 answer
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 real-world user. I thought it would be…
xof
- 35
- 1
- 1
- 4
2
votes
1 answer
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 diffrent user for writing, a diffrent user for deleting, and so…
Desert Wind
- 43
- 7
2
votes
1 answer
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 from sys.sql_logins:password_hash column.
My use…
SqlWorldWide
- 13,687
- 3
- 30
- 54
2
votes
1 answer
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 case the function is called by an external…
pascatl
- 123
- 4
1
vote
1 answer
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 giving error whenever I try to update a table in…
Danish
- 11
- 1
0
votes
0 answers
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
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 :
connect to the database
should be able to switch…
Subhajit
- 101
- 1
0
votes
0 answers
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 around for information about this and I couldn't…
Peter
- 79
- 5
0
votes
1 answer
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 database has grown to include private information…
Fandango68
- 295
- 2
- 11
0
votes
1 answer
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 were set up upon my arrival to the client. On server A and B there are Users,…
JOE_JOE
- 1
0
votes
1 answer
Unable to change password in postgres even though I'm logged in as that user
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'm currently using/logged in as (a root user).…
Jim
- 103
- 4
0
votes
1 answer
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 get:
Caused by:…
Hrvoje T
- 163
- 3
- 11
0
votes
2 answers
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), what is the worst he can do to the Ubuntu server…
sitems
- 103
- 3