Questions tagged [database-user]
The database-user tag has no usage guidance.
12
questions
0
votes
0answers
17 views
PostgreSQL :: Revoke access of information_schema and pg_catalog Schema [duplicate]
I would like to set up database as private as much as possible. The basic problem is that default access for 'PUBLIC' allows any user to get information about other existing databases, users, schemas, ...
0
votes
0answers
27 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 ...
2
votes
3answers
257 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 ...
2
votes
1answer
1k 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
1answer
82 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:\"...
0
votes
0answers
131 views
How can I manage newly created tables permissions in the PostgreSQL? [duplicate]
I want to create default permissions on the schema and automatically assign these permissions to newly created tables. For this purpose, I've created a role and assign a user. Afterward, I've created ...
1
vote
1answer
24 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 ...
0
votes
1answer
19 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 ...
2
votes
1answer
138 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 ...
0
votes
1answer
105 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://...
1
vote
1answer
27 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 ...
0
votes
0answers
68 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 ...
