Questions tagged [database-user]
The database-user tag has no usage guidance.
8
questions
0
votes
0answers
12 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
20 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
14 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. ...
2
votes
1answer
81 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
66 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
22 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
53 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 ...
