Questions tagged [users]

For questions about database user accounts.

Filter by
Sorted by
Tagged with
0
votes
0answers
21 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
12 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 ...
2
votes
2answers
100 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
27 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
26 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
22 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
306 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
23 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
22 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
76 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
63 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
27 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
20 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
90 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
14 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
27 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
65 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
61 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
15 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
32 views

Transfer AD Logins between Azure SQL Managed Instances

I am trying to transfer all logins part of an Azure SQL MI to another server. Have re-created the SQL logins with the help of 'sp_help_revlogin' script. Learnt that AD logins needs to be created ...
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
21 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
90 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
212 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
29 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
46 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
518 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
337 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
20 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
66 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
1k 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
26 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
32 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 ...
0
votes
1answer
80 views

Query for: view users and permissions (roles) from root security folder (MS SQL)

On the Internet I found a lot of scripts how to display users and their permissions under a particular database (Security folder under table) - for example sp_helpuser. Currently, however, I need to ...
1
vote
1answer
671 views

Is it possible to backup users from MongoDB admin database?

The title sums it up nicely. Essentially what I am asking is, if its possible to backup (use mongodump perhaps?) only users (accounts created for human users)?
0
votes
1answer
49 views

Are their any default privilege in Oracle for users?

I want to grant new users in Oracle the normal rules, for example, create a table, delete table update, in general, the default CRUD operations. Every time I do this manually by running a grant script....
1
vote
1answer
107 views

SQL server database Role management - Azure SQL MI

In my database I have multiple users with SQL server authentication login and AD login. For ex: User 1 and user 2 are from same team(ABC), if I create a role db_abc User 1 needs read access to table ...
2
votes
1answer
62 views

User and Schema Recreated during Stored Procedure Creation

As mentioned in the subject, a new user and schema are being created when a developer I'm working with creates a stored procedure. Originally I made a user and login for that developer individually ...
-1
votes
2answers
127 views

What are the SSL options to connect my new users to my PostgreSQL database

I want to create a new user in my database PostreSQL database hosted on Azure. So, following the documentation from Microsoft for pgAdmin, I went to PGAdmin and ran the following command: CREATE ...
0
votes
1answer
176 views

Unable to connect to oracle user

I have hit a rather frustrating snag in that after installing Oracle 18c. I have been unable to successfully create a user and then connect to it. More precisely I can create the user but the ...
0
votes
2answers
303 views

How can I find out if a user's password has expired in MySQL?

How can I find out if a user's password has expired in MySQL? The MySQL version I'm using is 8.0.16.
1
vote
1answer
419 views

How to view the user limits like max_queries or max_updates in MySQL?

How to show that I've imposed limitations for queries per hour ? Can't find anything online or notes. Would appreciate anybody's help on this.
1
vote
1answer
1k views

How do I force the delete of users from my database?

I am making a clean backup of our development database for easy fresh spin-ups of the database. This database has about 200 test users that should be deleted to make it truly clean, but the problem is ...
5
votes
1answer
1k views

Why can't I create a new schema with the owner set to dbo?

I created a test account for checking permissions against. It currently has the db_datareader, db_datawriter, and db_ddladmin roles for the Northwind database. But when it tries to create a new schema ...
4
votes
1answer
151 views

User Mapping on a DB that's part of an AG. DB is READ only? [duplicate]

I'm a sys admin being tossed in to a DBA role. I currently have two SQL Server boxes, 2016 Enterprise, in an AG. The DB has synchronized without any issues. A third party vendor needs to have an ...
0
votes
1answer
173 views

Add a DL as a login in azure sql managed instace

I am able to add individual AD logins as a login in azure sql managed instance, when i try to add a DL is the same way i am getting the following error. error: Principal '' could not be found or this ...
0
votes
1answer
28 views

Will an AD Account inherit all the User Mappings to databases that it's parent AD Group is mapped to?

If a Windows AD Group and an AD Account that belongs to that AD Group are both setup as Logins on a SQL server, will the AD Account Login inherit all the User Mappings that it's parent AD Group Login ...
1
vote
1answer
279 views

PostgreSQL read only user

We have a PostgreSQL database 'db1', which is having around 500 schemas. I am trying to create a read-only user for this particular PostgreSQL database. I could find the following command for ...
1
vote
2answers
42 views

Does an Oracle user have all privileges in its schema?

I'm learning Oracle and did some testing. I used the sys user and created a table t in the scott schema and I found t's owner is scott, and scott has full access to t. I want to confirm, does scott ...

1
2 3 4 5
7