Questions tagged [database-user]

The tag has no usage guidance.

5 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
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
22 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
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
59 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 ...