Questions tagged [database-user]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
0answers
7 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
52 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
25 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
17 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
35 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 ...