Questions tagged [users]

For questions about database user accounts.

Filter by
Sorted by
Tagged with
-1 votes
0 answers
19 views

Is it illegal to update db tables to remove user id and make it appear that the system updated it?

My employer wants to make massive updates to "save the time" of not entering the data through the GUI of business application. What worries me is that the data is auditable by federal ...
user avatar
0 votes
0 answers
18 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\....
user avatar
  • 1,198
2 votes
1 answer
30 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 ...
user avatar
  • 429
0 votes
0 answers
14 views

Unable to drop a user in AWS Redshift

I want to drop user foo from an AWS Redshift db DROP USER foo; ERROR: user "foo" cannot be dropped because some objects depend on it DETAIL: 1 object in database bar 1 object in database ...
user avatar
  • 171
0 votes
0 answers
10 views

password changed date of Mango DDB users

How can I find the password_change_date of users in MangoDB? Can I get a query to get this info.? For example in Oracle, we can gather it from dba_users table by selecting username, ...
user avatar
  • 1
0 votes
1 answer
27 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 ...
user avatar
0 votes
0 answers
22 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 '...
user avatar
0 votes
1 answer
96 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'...
user avatar
  • 179
0 votes
2 answers
39 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 ...
user avatar
  • 99
0 votes
1 answer
41 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 ...
user avatar
  • 1
0 votes
0 answers
43 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 ...
user avatar
0 votes
1 answer
66 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 ...
user avatar
1 vote
0 answers
21 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. ...
user avatar
1 vote
1 answer
290 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 (#...
user avatar
  • 637
0 votes
0 answers
36 views

User Table - Good Design w/ Request Rate Limit?

I would like to implement request rate limiting on my http server, for example for the "Forgot Password" form. I would like to allow 1 request per 10 minutes, for example. For this, I would ...
user avatar
  • 101
1 vote
0 answers
22 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 ...
user avatar
  • 167
2 votes
1 answer
196 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. ...
user avatar
  • 167
0 votes
1 answer
75 views

What Strategies are most advisable for managing users and their privileges in an AWS RDS Database?

Whenever a new database is created, best practices dictate that we should deploy alongside with it several users for several different activities. For example, a typical (at least to me) arrangement ...
user avatar
  • 183
0 votes
2 answers
77 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 ...
user avatar
0 votes
0 answers
128 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=&...
user avatar
0 votes
1 answer
70 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 ...
user avatar
1 vote
0 answers
553 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 ...
user avatar
0 votes
1 answer
352 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 ...
user avatar
0 votes
0 answers
45 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 ...
user avatar
0 votes
1 answer
420 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 ...
user avatar
  • 147
0 votes
0 answers
42 views

Create non-sysdba user that can grant tablespace to other users

I am creating an Oracle role with Admin option Grants so that user with this role assigned, will not be a full sysdba but will be able to create other users and grant them permissions. What I ...
user avatar
  • 177
5 votes
2 answers
3k views

How to set statement timeout per user?

I have multiple users in Postgres. I would like to set up different statement timeouts for different users. Eg: Guest 5 minutes and Admin 10 minutes. Is it possible in Postgres 11.11?
user avatar
2 votes
1 answer
379 views

Adding AD Security group to a SQL linked server

I have a question about adding permissions for a user group on a linked server in SQL Server. I am not a security specialist, so I appeal to everyone. Here is the topo: I have private software that I'...
user avatar
0 votes
2 answers
1k views

Can I GRANT SELECT on all schemas in a database?

I need to create role users of which can only read (select) data. I can do it for a particular schema. But I need it to work with all existing and future schemas (existing at least). How can I do it? ...
user avatar
  • 115
0 votes
0 answers
96 views

MariaDB default user accounts created during installation?

I have installed MariaDB 5.5.57 and phpMyAdmin 5.1.0 on my QNAP NAS. I notice that 7 user accounts were created during installation; What's the purpose of the three "Any" accounts, and do I ...
user avatar
  • 1
4 votes
2 answers
4k views

Why and how and where to use user without login

I've been trying to find why, how and where to use Users Without Login and I didn't find my exact question or anything that gets closer. Where I did my research (I also read other posts, saw Youtube ...
user avatar
0 votes
1 answer
151 views

Granting select on syscat.schemata - DB2

I was wondering if it is safe to grant select rights to syscat.schemata to users on a DB2 database? What could go "wrong"? Some tool like DataGrip and DBeaver cannot load connection schemas ...
user avatar
  • 143
2 votes
1 answer
60 views

Should roles without login have the connect permission on a database?

I want to create a read-only role in PostgreSQL and use it to assign it to multiple new users, who should have read-only access. It makes sense to me to also grant the read-only permissions to the ...
user avatar
2 votes
5 answers
497 views

CREATE Windows User in database for not existing domain

Is it possible to create a Windows User in the database when the domain is not accessible? I am preparing database at my dev environment outside of the targeted domain. Created user is not expected to ...
user avatar
  • 935
0 votes
3 answers
127 views

Allow user to create databases on server and to see only the databases that are created by him, without creating login first

I want to implement the following use case using C# application and MS SQL Server Express 2014. I have a centralized database server in which there are already created some database (which have the ...
user avatar
0 votes
1 answer
172 views

How to quota a CDB only tablespace to a CDB user?

I can create a CDB tablespace like this: (all using: sqlplus / as sysdba) -- create unique table space for admin CREATE TABLESPACE admints DATAFILE '/path/to/admints.dbf' SIZE 20M AUTOEXTEND ON; I ...
user avatar
  • 794
1 vote
1 answer
31 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 ...
user avatar
  • 11
3 votes
1 answer
142 views

PostgreSQL: Administration as Non-Superuser

I have a database on a shared PostgreSQL server. I possess the ownership of the database and the CREATEROLE privilege and would probably be able to get a few other privileges if I request them but I ...
user avatar
  • 133
0 votes
1 answer
24 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 ...
user avatar
  • 47
1 vote
0 answers
54 views

Create a user with rights and privileges between root and limited (CRUD single database) user

Is it possible to create a mid-root MySQL user, who will have the ability to create other users, with scope limited to databases which mid-root user creates? This mid-root user would not have the ...
user avatar
-1 votes
2 answers
171 views

How to create a same user in different PDB while it exists in other PDBs?

I have a list of 100 PDBs in the CDB, say the account_user exists in 50 PDBs and to create the same account_user in other 50 PDBs instead of logging into each PDB and creating user, is there a way to ...
user avatar
1 vote
0 answers
91 views

Is there any way to recklessly drop a principal leaving orphaned objects or should I assume only data corruption could cause it?

Given that SQL Server blocks me when I try to DROP a principal that owns an object in the database, if I see an object which the owner no longer exists, should I assume right away it was data ...
user avatar
  • 4,394
1 vote
1 answer
21 views

Should I revoke login from the default pgsql user?

I set up a localhost pgsql installation (os x catalina, homebrew, 12.*). I am developing a sql data warehouse and I’d like my dev environment to be as close to the production one as possible. Homebrew ...
user avatar
  • 51
0 votes
2 answers
22 views

Creating roles and granting rights to the role

I wanted to create a role called "user_updates" and this role should have the rights "table_note_updates". The rights called "table_note_updates" is already available in ...
user avatar
0 votes
0 answers
27 views

Why I cannot do this in SSMS directly? (assigning a LOGIN to a USER)

In SQL Server 2008 R2, I want to change the LOGIN for a USER in a database. FROM THIS: TO THIS: Initially, the database has the [...] dots option to change this greyed-out (why?): The only way to ...
user avatar
2 votes
1 answer
48 views

When should I reference the User record or User Profile record

I know it is a common paradigm to separate tables when building a User profile. For example, having a user table, and another table called user_profile with a foreign key to the user table. My ...
user avatar
  • 121
0 votes
1 answer
273 views

Changing default permenant USERS tablespace to bigfile

I'm trying to build an oracle database server but it's setting up the users tablespace as a smallfile. How can I either install brand new database with users being bigfile or changing the existing ...
user avatar
0 votes
1 answer
630 views

Copy MySQL User but change HostName

I am migrating to a docker MariaDB setup and all my users were created w/ "Localhost". From what I read and tested ironically '%' excludes localhost. I want to copy my existing users adding a second ...
user avatar
-1 votes
1 answer
32 views

User having execute procedure permission in MS SQL

Dears, Greetings, How can I create a new user in Microsoft SQL Database, so that user must have only execute permission on only 1 procedure in one of Ms SQL Database. Regards, Salahuddin.
user avatar
1 vote
2 answers
107 views

Unique constraint on 3 different columns but a specific value in 3rd column allows duplicate row entries

I have a 'Users' table with columns user_email, user_company_id and user_status. The user_status column is an enum with values '1' or '0' which represents the users being either active or inactive. Is ...
user avatar
  • 13

1
2 3 4 5
7