Questions tagged [users]

For questions about database user accounts.

Filter by
Sorted by
Tagged with
0
votes
2answers
29 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 ...
0
votes
1answer
22 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 ...
0
votes
0answers
22 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 ...
0
votes
1answer
24 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 ...
1
vote
0answers
16 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. ...
0
votes
1answer
21 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 (#...
0
votes
0answers
18 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 ...
0
votes
0answers
15 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 ...
1
vote
1answer
58 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. ...
0
votes
0answers
32 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 ...
0
votes
2answers
45 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 ...
0
votes
0answers
35 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=&...
0
votes
1answer
64 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 ...
1
vote
0answers
179 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 ...
0
votes
1answer
186 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 ...
0
votes
0answers
38 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 ...
0
votes
1answer
175 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 ...
0
votes
0answers
32 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 ...
0
votes
0answers
130 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 ...
3
votes
2answers
1k 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?
2
votes
1answer
182 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'...
0
votes
1answer
184 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? ...
0
votes
0answers
56 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 ...
4
votes
2answers
2k 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 ...
0
votes
1answer
75 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 ...
2
votes
1answer
34 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 ...
2
votes
5answers
299 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 ...
0
votes
3answers
110 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 ...
0
votes
1answer
94 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 ...
1
vote
1answer
24 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 ...
3
votes
1answer
111 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 ...
0
votes
1answer
19 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 ...
1
vote
0answers
32 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 ...
-1
votes
2answers
110 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 ...
1
vote
0answers
73 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 ...
1
vote
1answer
20 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 ...
0
votes
2answers
21 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 ...
0
votes
0answers
25 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 ...
2
votes
1answer
30 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 ...
0
votes
1answer
188 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 ...
0
votes
1answer
415 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 ...
-1
votes
1answer
30 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.
1
vote
2answers
76 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 ...
0
votes
0answers
834 views

ERROR 1130 (HY000): Host 'localhost' is not allowed to connect to this MariaDB server

My Users table crashed and I had to do a repair on it, now I'm getting the error: ERROR 1130 (HY000): Host 'localhost' is not allowed to connect to this MariaDB server No matter how I try to connect ...
0
votes
1answer
828 views

Postgresql: Permission denied to schema to user created based on master with rights

I'm trying to write a function that eventually will rotate users. Currently I have the code below which works and creates a new user using the prior user which ultimately has the same rights as the ...
1
vote
1answer
22 views

ALTER USER statement modifies users on off-air node

I had previously asked a question about Orphaned Users here and was directed to this link in an effort to fix it, but this didn't seem to answer my questions, so I am re-asking after some further ...
0
votes
1answer
75 views

Database level access in Azure SQL managed instance

In my Azure SQL managed instance I have two databases, Database_A and Database_B. User A_ABC has access only to Database_A and he is part of role db_owner. When the tries to alter a table we are ...
0
votes
1answer
3k views

How to find admin user of pluggable database in Oracle 12c up

I'm creating a script and I need to know what is the admin user of pluggable database. I don't find nothing about it in documentation. Other question is, what happen if I drop a admin user of the ...
0
votes
1answer
34 views

Defining password complexity and its action on "grace" state USERS

I have Oracle USERS linked to external applications that came to "grace" status. I tried to change the assword time expiration to unlimited but it doesn't apply to those account (considering I guess ...
0
votes
1answer
40 views

Manage Postgres user permissions with many databases and users

How do you manage users' permissions efficiently when your company has a lot of databases and users? My company has > 20 reporting databases. Whenever I need to change permission for some users, I ...

1
2 3 4 5
7