Questions tagged [users]
For questions about database user accounts.
273
questions
3
votes
1answer
51 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
0answers
21 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
22 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
52 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
38 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
34 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
24 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
30 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 ...
0
votes
1answer
80 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, ...
0
votes
0answers
13 views
How to model different entities that can have user accounts?
I need to model a system where Applicants can apply to Job Offers offered by a Company, but all that is through their User Accounts. How can I model that relationship? (I'll use MySQL) My ideas are ...
-2
votes
2answers
28 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
0answers
8 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
51 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
48 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
38 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
110 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
517 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
65 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
233 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 ...
0
votes
0answers
269 views
Column level security in SQL server
Is it possible to assign column level security in SQL Server directly on a table, without using a view?
For example, for table 'tbl', if I want column 1 to be restricted for user 1, is it possible ...
2
votes
2answers
174 views
Permission on Database [closed]
I have a login user called TestUser created at the server level that is assigned to a read only role, now I need to create a user for the TestUser login on MyDb
USE [MyDB]
GO
CREATE USER [Test] FOR ...
1
vote
1answer
116 views
Assign Permissions to a SQL User
I have active directory on my company, I have some login users created at the level of the SQL Server (2014) that I need to propagate to all my databases on that server. I want to create a read only ...
2
votes
1answer
472 views
Can't create read-write Postgresql user
I'm trying to create two users in a Postgres database—one with read-write access to all tables in two schemas, and one with read-write-create (i.e., able to make DDL changes) to the same schemas.
I ...
0
votes
1answer
42 views
How to check Auditing in Azure MSSQL MI?
I know that auditing is currently enabled in my azure MSSQL server, but how can I access these log files?
Could it be done through SSMS?
I need to know details about user activity in my databaase.
0
votes
1answer
49 views
MySQL logging max_questions resource
How would I know in MySQL if the user has exceeded his max_queries per hour?
I know that I can see this error on the client side, but I just want to know that before client is reporting to me, ...
0
votes
0answers
24 views
User host: % vs. blank
I'm currently studying db (MySQL). We were asked to create a user that can access a database from any host. I tried the following:
CREATE USER "user"@"" IDENTIFIED BY="pwd";
CREATE USER "user" ...
0
votes
1answer
319 views
Find queries executed by an user in sql server
I want to find all the queries executed by an particular user in a database over a period of time.
I learnt about trace and XEvents, but these are not setup yet, Will i be still able to get the ...
1
vote
1answer
244 views
Naming Convention for Login, User and Roles? [closed]
What are the Naming Conventions for a Login, A database User and a Database role?
Is there any best practice to follow?
0
votes
5answers
476 views
Create Role or Create user
PostgreSQL version : 11.2
OS platform : RHEL 7.6
I am new to PostgreSQL. I have a CRM application whose data I want to store in my 11.2 PostgreSQL Database.
The Database name will be : crm_db
The ...
0
votes
0answers
314 views
“Can't find any matching row in the user table” when attempting “SET PASSWORD”
When I do SELECT User, Host FROM mysql.user I see that I have a user named myuser on %. I tried setting that users password thusly:
SET PASSWORD FOR 'myuser'@'%' = 'mypassword';
Doing so, however, ...
1
vote
1answer
79 views
Privileges on SQL Server
I come from Oracle Database and now I am trying learn SQL Server and I don't undestand why may I viewer others databases, like the master for example, with a common user without privileges in this ...
0
votes
1answer
1k views
What's the difference between aud$ and dba_audit_trail tables in Oracle database?
I'm studying about audit in Oracle database and when I configure the audit using audit_trail = db the Oracle stores in the two tables
0
votes
1answer
34 views
Unable to create an user using mysql_embedded
I am creating a docker mariadb image and wanted to create a database and user name before bootstrapping mysqld daemon. So as per the documentation I tried below queries.
mysql_embedded -e "CREATE ...
0
votes
1answer
518 views
Cannot revoke permissions or drop user in PgSQL AWS RDS
I want to drop the user asd from the DB. So, I've got two DBs: foo and bar and the user apparently has dependencies in both. The DBs have been created from the root user postgres, but all tables and ...
0
votes
1answer
287 views
Postgresql createrole permission for user
I created a role with createrole flag, but users in this role trying to create users fail with permissions denied. Do I need to assign the createrole to each user instead of just the role (group)?
my ...
1
vote
1answer
52 views
Microsoft SQL Server v13 bulk add users from active directory
I would like to import all users from Active Directory into Security/Users.
What I do is the following:
Go to Security -> Users
Right click Users -> New User...
User type: Windows user, click on '......
2
votes
2answers
105 views
How can to make a new user see table in existing schema [closed]
I'm new into Oracle so this question might be dumb. I created new user and now I would like him to see table (or even better all tables by one command) in already existing schema (hr schema in this ...
4
votes
2answers
5k views
GRANT ALL ON ALL TABLES IN SCHEMA does not allow user to see tables
I have a pretty simple script to create a new database and to create a new user to access this database. This is run by the default postgres user. After granting access to the database and schema to ...
2
votes
1answer
1k views
How to access anonymous user account in MySQL?
I have followed the MySQL on Ubuntu 18.04 installation tutorial on Digital Ocean, and during the process of running mysql_secure_installation noticed the following:
By default, a MySQL installation ...
1
vote
2answers
4k views
Switch user to 'postgres' user on macOS results in “su: Sorry” error
The Postgres installers kindly provided to the community by EnterpriseDB.com creates a postgres user account on macOS as is common.
In a console session in Terminal.app, I need to switch to that user....
0
votes
2answers
90 views
Create users identified by the same password as another user in MariaDB 10.0.X
How do I create users with the same password as another user in MariaDB 10.x?
I do not know the password of the existing user , so i want to use same hashed password as existing, also do need to ...
1
vote
3answers
1k views
List all users on SQL Server for auditing
I'm using SQL Server Management Studio 17 and I'm trying to list all the users for auditing in an organized way with mentioning their database name.
I tried the query below but it's showing the ...
0
votes
1answer
110 views
How do I access a user's application username when that application connects to the DB?
I'd like to audit changes to a table in SQLServer using a trigger and an audit table to do so. End-users connect to the database through an application. If I use SYSTEM_USER to obtain the end user's ...
0
votes
1answer
2k views
Cannot login to postgres with newly created users
I have created a number of users in postgres using createuser --interactive --password but whenever I run sudo -i -u newuser I receive the following error:
sudo: unknown user: staging
sudo: unable to ...
0
votes
2answers
152 views
Update from PHP 5 to PHP 7.0 - PHPmyAdmin will show two server logins: localhost / localhost:3306
I updated my Linux 14.04 LTS to 18.04 and had to downgrade the PHP 7.2 to 7.0 as I need to run some software which is not capable of the preinstalled PHP 7.2. I used PHP 5 so far.
After I got ...
0
votes
0answers
390 views
New Sybase User can't SELECT Tables From Other User
I am accessing a Sybase database and have created a new user using:
CREATE USER "ThisNewUser" IDENTIFIED BY "ThisNewPassword";
I then granted privleges:
GRANT ALL TO "ThisNewUser"
I used the ...
1
vote
0answers
25 views
Ideal and Efficient Way of Handling User Logins with Multiple Types (i.e. Employee, Client, etc.)?
I'm developing a database where I will have two types of users: Employee and Client. I'm thinking it would be ideal to just have one big USERS TABLE with a user_ID as PK and Type column to ...
0
votes
0answers
34 views
Setting up a Database for Multiple User Access
I am working on revamping the database at the company I work at. I've been making decent progress getting various parts set up, but something occurred to me today that I hadn't really thought to ...
-2
votes
1answer
36 views
How to write a shell script to disable the database accounts from a list of user IDs
I am new to Unix scripting...I have a list of userids for terminated employees. I want to write a script that will check these userids against my databases and disable/remove the user accounts ...
