Skip to main content
Share Your Experience: Take the 2024 Developer Survey

Questions tagged [users]

For questions about database user accounts.

Filter by
Sorted by
Tagged with
0 votes
1 answer
25 views

MariaDB: Why do user sessions sometimes freeze

Sometimes, the sessions I initiate with mariadb -h local freeze. Here's my latest example: MariaDB [(none)]> SELECT u I'm certain that I did not hit any extra keys. Then I did connect once more ...
viator's user avatar
  • 1
0 votes
1 answer
22 views

Change MariaDB "ADMIN_OPTION" of a ROLE after deleting the user who created it

I have a problem in the prod : I have a user named dba who has all privileges with grant option, i used it to create a role named test, i granted some rights to the role test and granted the role test ...
Firas Megrahi's user avatar
1 vote
3 answers
78 views

Need a Role that can CREATE USER but not allowed to GRANT Predefined Roles in PostgreSQL <16

We are administrating DB in kubernetes to our customers. For each new cluster, we create a new user with CREATE ROLE and CREATE DB roles given to them, so that they can create their own databases and ...
imans77's user avatar
  • 111
0 votes
0 answers
29 views

import db and users from mysql 5

There's a working Mysql 5 database that I want to import into a MariaDB on another machine, including tables, data, users and privileges. Is There a pretty simple way to do that? I'm not so expert in ...
Remigio's user avatar
0 votes
0 answers
51 views

connection failed: FATAL: role "y" does not exist when .ini has role "x"

I have a Python program for PostgreSQL database management. Today it started throwing psycopg.OperationalError: connection failed: FATAL: role "role_a" does not exist Connection parameters ...
jvkloc's user avatar
  • 133
0 votes
2 answers
74 views

How to list available users in PostgreSQL having only the data directory?

I messed up a bit with a Dockerized PostgreSQL instance and accidentally overwrote the values I had for POSTGRES_USER and POSTGRES_PASSWORD. They were randomly generated, so guessing them is basically ...
illright's user avatar
  • 111
2 votes
2 answers
1k views

Unable to drop user due to assigned privileges?

How do you drop a user with read-only permission to PostgreSQL? I created a user, with read-only access to all tables, on an RDS Postgres database with: CREATE ROLE myuser WITH LOGIN PASSWORD '...
Cerin's user avatar
  • 1,365
0 votes
2 answers
55 views

MongoDB account -- is it an administrator's account?

I'm more familiar with MySQL, but in my new workplace, I have to look after a MongoDB database (MongoDB 4.2.18 with Mongosh 1.1.9 running on Ubuntu 18.04.6 -- yes, it's old; upgrading is a problem for ...
Ray's user avatar
  • 113
0 votes
0 answers
29 views

Managing database Users when restoring backups across environments

I have numerous Azure SQL Server Databases that teammates backup and restore. The issue we're running into is regarding the Users on these databases. We have Azure AD Groups that contain the ...
mt programmer's user avatar
0 votes
2 answers
475 views

Unable to connect to Oracle user in pluggable database

for some reason, i am unable to connect with any user that I create. their account status is also unlocked. I want to mention one thing; the pdbs are clone of the main pdb. (as shown by their name ...
dbafix's user avatar
  • 62
0 votes
0 answers
800 views

ORA 01918: user '...' does not exist

I am new to Oracle DB and I am currently working with Oracle Database 21c express edition. After the installation, I created a common user "C##OLUAKIN" so that I don't have to do my work on ...
tomiealff's user avatar
0 votes
0 answers
128 views

Can only use Oracle user when logged in as SYSDBA

I've just been setting up Oracle 19c on my Windows 10 Pro desktop following a hard drive failure. The install itself went well and I could log in with / as sysdba fine, but every user I seem to add ...
Robbie Dee's user avatar
0 votes
1 answer
745 views

SQL Server Job running as different user

A year or so ago I started working on a project to set up a job to run a stored procedure. I've now come back to this to finish it off. When I run the job I get an error that he job is running under ...
Keith Miller's user avatar
0 votes
0 answers
67 views

Can a user connected as sysdba always bypass auditing mechanisms?

Can a user connected as sysdba always bypass auditing mechanisms? What could be done to minimize (or prevent) auditing prevention?
Mehdi Charife's user avatar
1 vote
0 answers
83 views

Azure SQL: How can I share replicated db access with specific users?

I have 2 Azure SQL instances : db-main which is my main DB, containing both my-db and master databases. db-replica which contains a readonly replica my-db@db-main I have currently a user my-db-admin ...
Frédéric Camblor's user avatar
3 votes
2 answers
982 views

What the difference between User, Login and role in postgresql?

In my case I wanted to prevent table and view listing from db that has 2 schemas: public bi And I wanted to prevent any table and view listing from public to a specific user therefore I consulted ...
Dimitrios Desyllas's user avatar
0 votes
0 answers
194 views

what permissions does user need to have to use linked server and its default remote user mapping

i have some linkedserver and for it created default maping that mapping list is empty and all goes thrue 'Be made using this seciurity context' and this works fine - i can querry this linked from any ...
Dorian's user avatar
  • 103
1 vote
0 answers
293 views

Changing root and user passwords in MariaDB 10.5?

We have a few MariaDB servers (MariaDB 10.5, running on Debian 11/bullseye) where we need to change the passwords for the DB root user and for other user accounts in the DB system (by which I mean ...
dave559's user avatar
  • 121
0 votes
1 answer
2k views

Why SQL Server Job fails with "EXECUTE AS LOGIN failed for the requested login"?

I created a SQL Server job, in which: My user is set as the owner of the job No user is specified for run as at any step. The job failed with the error: 'EXECUTE AS LOGIN' failed for the requested ...
HeyJude's user avatar
  • 447
-1 votes
1 answer
294 views

SQL Server can't login in any user by SQL Authentication

So I just installed SQL Server Developer and SQL Management Studio in my personal computer. I have worked with SQL Server before but I never had to install and configure one so I was quite lost. The ...
Gustavo HK's user avatar
0 votes
1 answer
641 views

What is login token and user token in SQL Server?

I came across these two SQL Server catalog views today: sys.login_token and sys.user_token. The document states that they: Returns one row for every server principal that is part of the login token. ...
Fajela Tajkiya's user avatar
0 votes
1 answer
129 views

MySQL Not Resolving % in Host

Running MySql server 8.0.31 on an Amazon EC2 instance (52.99.189.74) in Ubuntu 22.04. When I log in to the mysql prompt with sudo, this is how the user and host columns of the mysql.user table look ...
Della's user avatar
  • 73
0 votes
3 answers
98 views

Store First and Lastname (Fullname) for Oracle Users?

Is it possible to store first-/last-/fullnames and possibly additional information of/for oracle user accounts in oracle? I look at the table dba_users but it does not contain such information. I need ...
Magier's user avatar
  • 4,787
0 votes
1 answer
117 views

Make all users within group role inherit permissions

I have a group role that consists of around 1,000 users. Those users do not inherit group role permissions, and I would like to make them all inherit them instead. What would be the way to do it ...
TimesAndPlaces's user avatar
1 vote
1 answer
179 views

How do you create an atlas user in a non-admin db?

There doesn't seem to be an option in mongo atlas UI to create a user in any database other than admin.
Sudh33ra's user avatar
  • 111
1 vote
1 answer
3k views

password authentication failed for user "postgres"

The sample.sql is simple. create database test; The settings on /etc/postgresql/13/main/pg_hba.conf. local all postgres md5 local all all ...
showkey's user avatar
  • 334
0 votes
2 answers
416 views

Grouping user into Role to access FDW table

Recently I setup Forward Data Wrapper. Here is what I do: CREATE SERVER foreign_server FOREIGN DATA WRAPPER postgres_fdw OPTIONS (host '192.168.125.1', port '5432', dbname 'template1 '); IMPORT ...
padjee's user avatar
  • 187
2 votes
2 answers
2k views

DACPAC drops existing users and permissions from database when upgrading through SSMS

I'm developing my database through a database project in visual studio, and whenever I need to upgrade the schema of my database I like to use SSMS to do this using a DACPAC. But whenever I use my ...
Emil Skovmand's user avatar
0 votes
1 answer
513 views

Do Postgres Roles carry over from Databases if Databases are in the same server?

If I am creating a new Database on the same hostname/server, Will the roles/users carry over? Or will I have to create them again with new names and passwords? I see roles/users listed as server ...
user16573033's user avatar
-4 votes
1 answer
50 views

create a oracle database user with no object in tablespace [closed]

Create user Sara with a password of sara. Make sure that any objects not created in the system tablespace and Sara can log in and create objects up to 10M in size in the MYUSERS. how to create a ...
005 maira sultana's user avatar
0 votes
0 answers
722 views

What's wrong with my user mapping in pg_ident?

I have successfully setup certificate based authentication in postgresql-11. Now I want to do a user mapping: pg_ident.conf # MAPNAME SYSTEM-USERNAME PG-USERNAME mymap /^(.*)\.testnet\....
daisy's user avatar
  • 1,328
2 votes
1 answer
749 views

Error trying to add a login to Azure SQL Special Role 'dbmanager'

Upon running these commands on an Azure SQL instance: CREATE LOGIN test WITH PASSWORD=N'Passw0rd' GO ALTER ROLE dbmanager ADD MEMBER test GO ... I'm getting an error: Cannot add the server principal ...
InteXX's user avatar
  • 559
0 votes
1 answer
154 views

Best practise making users in Maria db database

Iam creating a basic banking database to practise MariaDB, so I wanted to know what the general guidance on what kind of users you should be making and what type of privileges? Currently I have a read ...
mathewsjoyy's user avatar
0 votes
0 answers
29 views

Maria DB not letting me creating more then 1 user at once

I am trying to make a read only and a full privledge admin user to my database with the following code: DROP USER IF EXISTS 'readonly'@'localhost'; CREATE USER 'readonly'@'localhost' IDENTIFIED BY '...
paigelarry342's user avatar
0 votes
1 answer
3k views

Create readonly user in postgresql

Using pg 13.4, created a readonly user reader for database abc, via: CREATE ROLE reader WITH LOGIN PASSWORD 'psssswwwd' NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE NOREPLICATION VALID UNTIL 'infinity'...
Eric's user avatar
  • 253
0 votes
2 answers
179 views

How to make a restricted view in oracle?

I had to provide data for an application schema, but there is a requirement that the applications connecting using that schema user cannot query more than five rows at a time, the application queries ...
alibttb's user avatar
  • 99
1 vote
1 answer
1k views

How to create a mysql user that can access from any host but localhost

I was asked to create a mysql user that can connect to the server from any host but localhost. I tend to believe that "%" also means localhost but according to my teacher, localhost is not ...
ptor's user avatar
  • 11
0 votes
0 answers
352 views

See Max Simultaneous Sessions Per User

In an effort to set a reasonable sessions_per_user profile setting for shared database accounts or other non-unique account (ie. an account an application uses to log into the database for all app ...
Jeff Bauersfeld's user avatar
0 votes
1 answer
626 views

Data from other user not visible

I am using Oracle and SQL Developer to create a database. I am fairly new to SQL, so this may be a simple question. I have my SYSTEM user, who owns several tables, for example this one: CREATE TABLE ...
Владислав Крутенко's user avatar
1 vote
0 answers
100 views

Can you synchronize user accounts with specific DB permissions with records found in a table?

Background / Current Setup I have a database in a SQL server that uses row level security to determine what records a user has access to. Users will have two methods to interact with the database. ...
Mandelbrotter's user avatar
2 votes
2 answers
6k views

In trino I keep getting `Access Denied: Cannot select from table system.jdbc.tables`

I just created a new user dataengineer and user group data-engineer When I try to connect with the user dataengineer using dbeaver I get the following errors. SQL Error [4]: Query failed (#...
nelaaro's user avatar
  • 727
1 vote
0 answers
80 views

Azure SQL database make AD user see more databases in SSMS

I'm using Azure SQL databases and want to add a user from my company using Active Directory auth, so adding the user from external provider. The problem - by design Azure SQL creates AD users as ...
Tessaract's user avatar
  • 167
2 votes
1 answer
1k views

CREATE LOGIN "MUST_CHANGE" does not work for Azure

I want to create logins for users for my Azure SQL database. Naturally I don't want to know the users' passwords so I want to set it up so that they HAVE to change their password on first login. ...
Tessaract's user avatar
  • 167
12 votes
2 answers
27k views

Is there a simple way to add a read-only user?

I have a hosted (shared) SQL Server database and I'd like to add a read-only login. (This login will be used to build Power BI data visualization.) Looking into this, it's far more complex than I ...
Jonathan Wood's user avatar
0 votes
0 answers
659 views

Revoke CREATE for a user from Google Cloud SQL Postgres?

I'm using Google Cloud SQL Postgres and having difficulty revoking privileges to create tables from a user. I first removed all roles and attributes from the user (truncated for brevity): mydatabase=&...
ashgromnies's user avatar
0 votes
1 answer
2k views

How to restrict Users to see only their databases where has access? [duplicate]

I need to restrict the list of database for our users in a SQL Instance In order to move forward this I revoked the view any database permission to the user desired. But I figured out that only ...
SakZepelin's user avatar
1 vote
0 answers
2k views

Create multi-user database schema with roles, permissions, and services

I am in the process of designing a user administration database and I am stuck in the creation of the tables and their relationships, in order to explain myself below I expose the requirements of the ...
Kelebra93's user avatar
0 votes
1 answer
1k views

Drop role postgresql

I just inherited an AWS RDS PostgreSQL 12.5 instance (so, no superuser access) and I'm required to do some cleanup and delete a bunch of groups/roles/users. I'm executing the following commands with ...
Daniel Huesca's user avatar
0 votes
0 answers
97 views

AAD users lose access to database after import

I googled for the last few days but I got a bit confused and I do not know how to proceed further. Also, I'm not a DBA and I was just faced with this situation for the first time. Using sqlpackage.exe ...
Roxananana's user avatar
0 votes
1 answer
2k views

Can't create schema for a db with PostgreSQL

Use psql -U postgres to login. postgres=> CREATE DATABASE mydb; postgres=> \c mydb; You are now connected to database "mydb" as user "postgres". When create schema, got ...
Miantian's user avatar
  • 167

1
2 3 4 5
8