Questions tagged [database-user]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
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 ...