Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [users]

For questions about database user accounts.

2
votes
2answers
129 views

Permission on Database [on hold]

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
50 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
38 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
33 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
0answers
4 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
21 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
49 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 ...
0
votes
1answer
35 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
48 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
30 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
62 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
100 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
27 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
0answers
99 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
44 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
40 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
103 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 ...
2
votes
2answers
1k 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 ...
1
vote
1answer
243 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
910 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
45 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
259 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
47 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
640 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
68 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
118 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
20 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
31 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
26 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 ...
10
votes
4answers
6k views

What does a RED X on a database user mean?

I created two new AD groups and added them as users of a database but they show with a RED X. What does this mean? Thanks.
1
vote
0answers
27 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: ...
2
votes
2answers
263 views

Mysql 8.0 and read-only not working as expected

I have a new Master/Slave config running. Everything is happily replication. I have added a secondary user whose role will be to manage the databases and tables. Currently the following privileges ...
1
vote
1answer
48 views

Create domain user offline

Can I add domain users to a database, when Sql Server A (the development server) is not part of the domain and has absolutely no access to the domain? The domain users are of course not expected to ...
3
votes
2answers
838 views

Which characters are allowed in MySQL/MariaDB user account names?

It's not clear to me which characters can occur in MySQL/MariaDB user account names, and which are illegal. I've read section 6.3.1 "User Names and Passwords" in the MySQL documentation. This section ...
1
vote
0answers
202 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 ...
0
votes
1answer
174 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
29 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 ...
1
vote
1answer
85 views

Object Level Security

I have a database that will be shared across multiple related types of applications for different users. I want to be able to restrict each database user to essentially have full control over their ...
4
votes
2answers
1k views

SQL Server Service Accounts

We have a new Windows 2016 server and I have to install SQL Server 2016 standard edition. Once I install and configure the SQL server I will move my existing production database to the new db server. ...
0
votes
1answer
319 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
40 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
47 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
1answer
1k views

mysql.user table damaged suddenly

I didn't do an upgrade or anything but suddenly MySQL (MariaDB) stopped working after a restart. This is the log: 2018-02-11 14:10:02 140193631740480 [Note] Using unique option prefix '...
2
votes
2answers
902 views

EXECUTE AS USER = 'dbo' - The user does not have permission to perform this action

I created a trigger that now works fine as result, but there is 1 line where I run a query: DECLARE @source as nvarchar(30) = (SELECT client_net_address FROM sys.dm_exec_connections WHERE session_id =...
0
votes
1answer
50 views

How to create mysql user with CREATE USER grant but without access to new databases?

I need mysql admin_user (not root user) which can create write_user with permissions: CREATE, UPDATE, INSERT, DELETE and SELECT. admin_user and write_user have access to main_db. write_user will ...
6
votes
1answer
366 views

Disable multiple logins in one step

Is there a way to disable multiple sql logins based on a set of users in a table? For example: ALTER LOGIN (Select userid from tbl_user) DISABLE;
0
votes
1answer
91 views

Authorization dbo maps to a user with an old machine name

I am trying to run a command that looks like this: Create ASSEMBLY [AssemblyName] AUTHORIZATION [dbo] From ... When this runs, it returns an error message: Could not obtain information about Windows ...
1
vote
1answer
662 views

postgres create limited user that can select tables and columns of those tables

I have an app that automates the making of a PostgreSQL database, and also automates the creation of a database user. This database user is given limited access for security purposes, as it will be ...
2
votes
1answer
2k views

pg_hba.conf allow mutliple I.P. addresses for single user

In my pg_hba.conf, I need a single user to be allowed to connect from two completely different IP addresses (like work and home, for example). Something like the following would be really nice: host ...
-1
votes
1answer
55 views

Authorized, all privileged DB user and a DB instance with the same name - does it have a name? [closed]

Is there a term that encompasses an authorized, all-privileged DB user and a DB instance with the same name? Should I call this a DB stack / DB unit / DB packet / something else? Does this "stack" ...