Questions tagged [database-user]
The database-user tag has no usage guidance.
12
questions
0
votes
0answers
25 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
60 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
216 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
28 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
30 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
23 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
18 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 ...
0
votes
0answers
11 views
In Redshift how can I create an user which which has only user creation privileges?
The primary requirement is to automatically create or alter users based on user information stored in a table. I am planning to write a stored procedure / use Databricks notebook to do the automation. ...
2
votes
1answer
113 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
80 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
23 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
65 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 ...
