Questions tagged [users]
For questions about database user accounts.
312
questions
0
votes
0answers
4 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
17 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
298 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
20 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
20 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
70 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
62 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
87 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
61 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
60 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
14 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
29 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
85 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
187 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
45 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
473 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
309 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
63 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
23 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
78 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
619 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
48 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
105 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
59 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
120 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
165 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
251 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
379 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 ...
4
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
143 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
167 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
275 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
41 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
vote
1answer
94 views
Why do I have different usernames from mysql.user and select user()?
With 10.4.6-MariaDB on my Mac OS 10.14.5
Logged in as root I can see the list of users on my server with
MariaDB [(none)]> select Host,User from mysql.user;
+--------------+-----------+
| Host ...
1
vote
0answers
59 views
SQL Server Permissions for Intellisense for an Active Directory User? [duplicate]
I have created an Active Directory Group and created it as a user, we'll call it "AD SQL", in my DB. I can successfully login in using Active Directory Authentication and read/write.
However, ...
0
votes
1answer
49 views
How can I setup users/groups in PostgreSQL so that each user has privileges on objects created by other users in the same group?
I have created a group (role) called "employees" and I've created some users that are its member and that inherit its rights. I have a database owned by the group "employees".
The goal: To setup ...
-1
votes
1answer
2k views
Assigning Permission on Azure SQL Database
I have an azure SQL Database. I already created a new login and user on the database. Question is i want to assign permission on the said user. Permission that will restrict the user to drop table, ...