Questions tagged [users]

For questions about database user accounts.

52 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
3
votes
0answers
1k views

How to change username to connect to server in pgadmin4 in query tool?

Back in pgadmin 3, I could change the username in the query tool by clicking on postgres on postgres@localhost:5432 dropdown: However, I don't see this option in pgadmin4. How do I change the user ...
3
votes
0answers
1k views

How to set up users in SQL Server 2008 Express over workgroup? (no domain)

The situation is this: simple network, one server not a domain controller, running SQL Server 2008 Express (64bit). 8 workstations running windows 7 pro connected to it. Last week after Windows ...
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 ...
2
votes
0answers
207 views

Default privileges granted only if table created by one superuser

I have a role group called normal_users, my username is rbourgeon (I am superuser) and there is another superuser called admin. I previously ran the following query: ALTER DEFAULT PRIVILEGES IN ...
2
votes
1answer
60 views

SQL application connection using one Windows user

We are currently looking to update an old application security structure and would like to go for an approach where the application connects to SQL via one Windows login with the required Read/Write ...
2
votes
1answer
300 views

User created automatically because of AD Group?

I have a Development SQL Server that I'm managing with Active Directory Groups, sometimes when I do my checks on the server I find that some users were "automatically" added to SQL Server Database ...
2
votes
0answers
731 views

How do you grant SQL Server 2016 user-permissions to access local files?

I'm trying to develop a SSDT sln, where a .csv is parsed. However I get the error: Operating system error code 5(Access is denied.) According to this post: https://stackoverflow.com/questions/...
2
votes
0answers
100 views

Is this user-storage database system efficient, effective and secure?

I am using: PHP Version 5.2.17-MIT-BACKPORT-GnuTLS SQLite 2.8.17 I have a database called users, which currently has a table called root. There will be others, once I get all the rows for root ...
2
votes
0answers
489 views

How do I authenticate a Database User by a LDAP Server and then to login with the SQL Developer, without using the OID/Apex?

I want to create a global User, identified by a LDAP_DN. My Problem is: I can automatically create users, but when I try to log on to the database, I get the error message that the login data are ...
2
votes
1answer
65 views

Moved database to new server, not sure about NT AUTHORITY\* users

I just moved database to new instance of SQL Server (SQL Server 2012 Web from Amazon EC2) and am now cleaning up database users. I am not sure if/why these 2 users are needed (they exist in original ...
2
votes
0answers
82 views

How can I copy a user while preserving all privs?

We're changing domains. I'd like to create a new account for myself, NewDomain\Bob which has the same su-level privileges as OldDomain\Bob, to minimize the chance of disruption when IT flips the ...
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
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 ...
1
vote
0answers
35 views

Exception for grant create user

I'm trying to create an account (tenant) which has full privileges on all databases called test_... It should also be able to create other users with also only privileges on those databases. As root: ...
1
vote
0answers
80 views

are there possible draw backs when setting 'dbo' to users who have default schema as null?

as part of a bigger operation I have been putting together this script below that basically generates a create user script for each user of the current database. When the user has a default_schema it ...
1
vote
0answers
191 views

PostgreSQL: Recommended way of user creation/management for development, test and production. I use Ruby on Rails

I am trying to think of the best (aka recommended or common professional practice) way to create users/roles in PostgreSQL database for development, test and production environments. I have to say ...
1
vote
1answer
453 views

Auditing AS 400 DB2 library user access

As part of the testing to check for authorized users having access to applications and libraries on AS 400 systems, I need help to figure out a list of users having access to applications hosted on ...
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
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
71 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 ...
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
19 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 ...
0
votes
0answers
264 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 ...
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
46 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
0answers
308 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, ...
0
votes
1answer
33 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
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
0answers
378 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 ...
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 ...
0
votes
1answer
272 views

MySQL user export PASSWORD is showing up as <secret>

I am trying to export all users from old MySQL server to new. All the methods that I tried shows the PASSWORD as <secret> pt-show-grants phpMyAdmin 4.8.1 https://serverfault.com/questions/...
0
votes
1answer
30 views

SSRS 2014 Exec Log gives the Service Account as UserName instead of Actual User name

I am using the below query for accessing the Users who are using the Application Reports. SSRS 2014 gives the Service Account(IIS Account used for Application) as User Name instead of Actual User ...
0
votes
1answer
52 views

Track MySQL Procedure Changes in MySQL

We want to keep track of changes being done to MySQL procedures only, actually recently our procedures seem to have overwritten to some previous versions and we were unable to track it that who did ...
0
votes
1answer
95 views

How to create a database user for oracle 11g on windows 8?

I am new to oracle database and therefore is trying to follow the office guide. (link to the guide) However, it seems that the guide is for Windows 7, so in step 2 - creating database user, it says: ...
0
votes
0answers
100 views

Grant user permission to create new schema but not view existing schema

Is there a way to allow the user to create new schemas (and acquire privileges to schemas he created), but not view existing schemas (or a way to blacklist a list of schemas that the user is not able ...
0
votes
1answer
63 views

How to allow creation and deletion of a database or collections with user and password

I created a user with the role of userAdminAnyDatabase db.createUser({user: "Username", pwd: "password", roles: [{role: "userAdminAnyDatabase", db: "admin"}]}) and also user with the role of ...
0
votes
1answer
29 views

MySQL - Unable to login with password, but without password its working

I have a master-slave setup, Slave is not in read only mode.(we can do all writes). I have created a user. create user 'bhuvi'@'%' identified by 'bhuvi'; grant all privileges on *.* to 'bhuvi'@'...
0
votes
1answer
35 views

A trigger that show the user that has made an insertion

I have the following code create table o_c( op_id NUMBER(10,0) PRIMARY KEY NOT NULL, n_c VARCHAR2(50) NOT NULL, op VARCHAR2(500) NOT NULL, amount NUMBER(9,2) ); create table a_o( a_id NUMBER(10,0) ...
0
votes
1answer
37 views

How to rename MySQL users without logging into MySQL?

I wanted to rename the default Linux username on a Lubuntu 16.04 VM (from osgeo live) from user to newuser. I followed answers in this question to rename the Linux user. But after renaming, I cannot ...
0
votes
1answer
26 views

Is there any database system that allows to have different schemas for different users but the same content for all users?

In my fantasies, it looks something like this: User 1: SHOW TABLES; +-----------------------+ | Tables_in_my_database | +-----------------------+ | table_1 | | table_2 | +...
0
votes
0answers
121 views

SQL Server Phantom Login

I have log shipped a database from one SQL Server 2008 R2 server to another in standby mode for reporting purposes. Permissions are granted via a Windows AD Group called DOMAIN\DB Access Group which ...
0
votes
0answers
186 views

Restored database is missing user

I have a SharePoint content database that has been restored into our test environment. I am getting errors in the SQL log indicating our SharePoint service account is not able to access the database. ...
0
votes
1answer
26 views

Restricting the # of Rows a User can return in a single query

A concern has come up recently about employees who have read access to our internal databases being able to download large amounts of data for nefarious purposes. My question is whether it is ...
0
votes
0answers
22 views

Usermanagement and a database pr user

Is there any easy way to manage users? Let's say, I need another user called user2. This user needs a database called user2 aswell - With only privileges to THIS database. It's easy to do, just by ...
0
votes
1answer
644 views

How to structure a MongoDB database to allow for multiple users to use the same account with restrictions based on roles?

Ok, firstly I'm very new to MongoDB, and newish to DB development/management as a whole. I've done a unit using Oracle through uni, but apart from just manipulating fields through the phpmyadmin ...
0
votes
1answer
112 views

ORA-01017 error when conecting to Oracle Database Standard Edition 2.12.2.0.1.0 for Microsoft Windows x64 (64-bit)

I've installed and created non-CDB database (single tenant) database. Created a user account using the SYS user, granted it the CONNECT and CREATE SESSION roles. When I attempt to login using the ...
0
votes
1answer
125 views

Unable to drop database user without login

One of our developers with blanket privilege on a database wanted to create a regular user mapped to a login when what he mistakenly created was a user without login and now I'm unable to remove the ...
-1
votes
1answer
40 views

Users' physical characteristics - design

I have to build a database for an employment agency. For each user will be stored physical characteristics like height, weight, hair color...(9 fields in total). I thought I could just build a ...