Questions tagged [users]
For questions about database user accounts.
302
questions
1
vote
1answer
11 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
20 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
26 views
Specify Host for User in docker compose file
I've started messing with Docker and the MySQL 5.7 image, and have created a docker-compose.yaml file to quickly bring up a DB instance with the root password set, a new user & password created, ...
0
votes
0answers
6 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
24 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 ...
0
votes
0answers
9 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
22 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
25 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
27 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
40 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
87 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
25 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
18 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
0answers
17 views
Fixed Orphaned Users on 2nd Node, but 1st Node Users Permissions Changed [duplicate]
For context: My environment consists of two Windows Server '19 boxes with SQL 2017 running in an AlwaysOn High Availability & WSFC configuration.
I have run into an issue where several login ...
0
votes
1answer
35 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
119 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
19 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
28 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
45 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
115 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
0answers
32 views
Estimate of number of connections to a sql server instance
I want to get a proper or near accurate count for the number of connections in a sql server instance.
I have been using different queries from internet and i see that some people use dmvs ,some people ...
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....
0
votes
0answers
35 views
Can a user have more than 1 profile assigned in Oracle?
That's my question, as simple as it seems.
I actually wasn't able to find the answer in the Oracle documentation, so I came here for asking.
Still, I tried this query
SELECT USERNAME, PROFILE FROM ...
1
vote
1answer
60 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
37 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
68 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
68 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
46 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
103 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
356 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 ...
2
votes
1answer
264 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
86 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
102 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
26 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
186 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
40 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
46 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
42 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
40 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
1k 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, ...
-2
votes
2answers
345 views
find date and time user last access database [closed]
I need to find the last time a user accessed the database. I am new to SQL and rarely have to use it. Details would help or links to learn those details.
0
votes
1answer
17 views
Details about existing roles and users in azure sql database
I would like to get details of all users existing in a sql server DB and the respective roles they are part of and the permissions granted/denied for the a role/user.
what is the best way to get this ...
0
votes
0answers
20 views
MYSQL need log executed query in table along with executed user name
I would to like the executed quires with entire database tables for some mysql users only. Because some of users executed wrong query in production environment. And needs to store this log in new ...
1
vote
0answers
55 views
How to Measure data consumed by an user in Azure sql server database?
For an Azure sql server MI, we have multiple external users consuming data,
I would like to know how much data an user is consuming/extracting from the DB?
Can this be checked from,
1.) From SSMS ...
1
vote
2answers
58 views
Can a user with readonly access change SQL server settings
Database administration is not a strong point of mine, and I was wondering if a user with read only access can change the server settings.
In their query I can see this at the beginning:
SET ...
0
votes
1answer
45 views
Orphaned users with their respective database name [duplicate]
I need to get a list of the orphaned users in each DB, together with the database name in which they are found in. I did the below which gives the orphaned users in each DB, but I cannot figure out ...
1
vote
1answer
368 views
Delete orphaned SQL Users
I have a Microsoft SQL Server that had a database called SQLDATABASE. It also had a user called SQLUSER. The SQLDATABASE was deleted but not SQLUSER. SQLUSER only belonged to SQLDATABASE. I want to ...
0
votes
1answer
2k views
Cannot open database “dbname” requested by login.The login failed.Login failed for user 'DOMAIN\Windowsusername'
I had a database which i dropped using the below command.
USE master;
GO
ALTER DATABASE dbname SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
GO
DROP DATABASE dbname;
Now when i refresh the connection in ...
1
vote
1answer
74 views
Granting permissions to a DB user - SQL Server
I need to grant select and update permissions to a DB user (TestUser) on TestDB database as per below.
When I press ok and re-check the permissions, they are not visible as can be shown below:
From ...
0
votes
2answers
738 views
User and login mapping after an SQL Server restore
I need to restore a DB from an SQL Server instance to another and I am well aware that the DB users will be transferred but the logins won't. I have created a script to be able to create the logins on ...
