Questions tagged [database-user]
The database-user tag has no usage guidance.
9
questions
2
votes
1answer
104 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 ...
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 ...
1
vote
1answer
21 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
68 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://...
0
votes
1answer
21 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
13 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 ...
0
votes
1answer
16 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
10 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. ...
0
votes
0answers
56 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 ...
