Questions tagged [users]
For questions about database user accounts.
0
votes
1answer
19 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
28 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
18 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
33 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
101 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 ...
1
vote
2answers
424 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
82 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
270 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....
2
votes
0answers
35 views
Modeling Database to Support Sub-Users for Users [closed]
I'm having a hard time wrapping my head around how to best model my relational database. I want to be able to structure it in such a way that a User on my site can create Sub-Users that are able to ...
0
votes
2answers
43 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
131 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
41 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
372 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
42 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
58 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 ...
0
votes
0answers
23 views
How to create a user in postgres that has a access to particular schema
I want to create a user in the postgres database which has read access to a particular schema in the database. how can I create that?
eg:- if in case a database has 3 schemas public, test and test2. ...
-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 ...
0
votes
0answers
22 views
How to connect to mdb fie
I have a exe file that read and write from local Db file.
I check this file with Detect It Easy and it tell me that is mdb file.
I can open this file with Microsoft Access, and watch all the tables ...
9
votes
4answers
4k 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
25 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
171 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
46 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
513 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
199 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
126 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
28 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
69 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
959 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
0answers
229 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
29 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
45 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
868 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
719 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
44 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 ...
0
votes
0answers
82 views
User table definition when using an third-party Identity Provider
As-Is
The user table has a classic structure where everything is mixed in a single table:
id BIGINT PRIMARY KEY
idp_id TEXT NOT NULL UNIQUE -- user ID in the Identity Provider ...
6
votes
1answer
332 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
59 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
511 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
1k 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
54 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" ...
2
votes
2answers
408 views
MongoDB Cluster - Can't access member of shard with credentials
I have a Sharded Cluster and I am trying to access a specific member of a replica set within a shard.
When connecting to the mongos it is fine, but when using the same credentials on a member of the ...
-1
votes
1answer
46 views
Getting User Access in Individual Databases MSSQL
So, here is the scenario.
I need to give user access on multiple databases ( but not all on the instance), and in this case, i cannot use AD group which is already having certain grants on all ...
4
votes
2answers
3k views
Cross-database view - Not able to access database under the current security context
We have two databases, Adb and Bdb. In Bdb, we create a view that references another view in Adb, like so: CREATE VIEW Bdb.dbo.Bview AS SELECT * FROM Adb.dbo.Aview.
We have an SQL Authenticated ...
0
votes
0answers
68 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 ...
3
votes
1answer
686 views
What is the significance of the principal_id in sys.schemas?
What is the meaning of the principal_id in sys.schemas and when would it ever be different from schema_id?
1> SELECT LEFT(name,20), schema_id, principal_id FROM sys.schemas;
2> GO
...
1
vote
2answers
1k views
Expiration date on a user in a specific database
Some of our developers needs access to some of the databases in production for a short period. Is there a way for me to set an expiration date on a user in a specific database?
Just to clarify I do ...
2
votes
1answer
622 views
Minimum credentials on SQL Server to connect via Power BI Desktop
Note: This is not a Power BI issue, this is a DB credential issue.
In Power BI Desktop, I am trying to connect to a database, but I only want that user to have SELECT access.
I have one User that is ...
0
votes
3answers
127 views
Disabling password change for a MySQL user
Is it possible for MySQL users to prevent/disable changing their password with just the USAGE option? There are no global permissions allowed.
I tried to google, but had no luck.
