Questions tagged [users]
For questions about database user accounts.
361 questions
0
votes
1
answer
667
views
Restrict contained SQL Azure user to read-only access
I am trying to create a contained user for a database in SQL Azure that only as read-only access. What I am doing is:
Connecting to the database via SSMS using my admin account.
Right click the ...
- 691
0
votes
1
answer
232
views
SQL query for number of users [closed]
I'm very new to SQL, so really need some tips.
I need some help building a query that'll get me all users that have logged into to our platform over the past 12 months.
- 9
2
votes
2
answers
4k
views
Should I disable the guest user on system databases
The guest user is disabled on our user databases but data security guys want us to disable it on system databases as well. Should I do it?
- 21
5
votes
4
answers
15k
views
Compare two users permissions on SQL Server database?
Is it possible to compare permissions of two users on one SQL Server database?
Is there any simple query to do it?
I am asking this because I want to find out if user B has different or same level of ...
- 185
0
votes
1
answer
248
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,550
3
votes
2
answers
5k
views
SQL Server - Windows Group Authentication
I am trying to understand how to create Windows Group based access to a SQL Server (2012) database the right way. I was able to successfully add a Windows group to the Server Login and I have a ...
- 151
8
votes
2
answers
16k
views
Create a user with privileges to create users
For our software we need a MySQL user who is able to create other MySQL users. This is possible with the MySQL root user but we do not want to use the root user in our software application. Is there a ...
- 183
4
votes
1
answer
13k
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 ...
- 141
0
votes
2
answers
358
views
Scipt User roles and permissions
I am having issues with the user accounts in SQL Server v 11.0.6020. I need to run a script that will allow for the copy of the principal user account: 'TrainID1' and all of the user rights and ...
- 9
11
votes
2
answers
21k
views
Username length restriction in different MySQL environments
I am setting up a project to my local environment and at its initial script are some SQL commands for creating the database:
create database 'db-name' default character set utf8;
and to grant ...
- 213
6
votes
3
answers
10k
views
Postgres Large Objects & Multiple Users
Problem
Dynamically created users are not able to query a table that contains Large Objects as it did not originally create it.
Background
I have an Java Atom Hopper application deployed to AWS ...
- 163
2
votes
1
answer
1k
views
How to make a Root to get access to the MariaDB server, trough a client app like MysqlWorkbench?
I am running a brand new Ubuntu 16.04 virtual machine to perform some testes with MariaDB AND Nginx AND PHP7.
When I was installing MariaDB (trough apt-get install mariadb-server) I was not asked to ...
- 337
1
vote
0
answers
91
views
How to give select privileges to database in postgreSQL [duplicate]
How can we give select access at database level in postgreSQL.
At present I had created new user with select access on all tables in a schema using below syntax.
grant select on all tables in ...
- 1,007
4
votes
3
answers
5k
views
Assign db_owner to all users at once
I need to assign db_owner to all users within an instance. There are a few hundred logins and same number of databases within the instance. I would like each user to get db_owner within the database ...
- 508
8
votes
1
answer
24k
views
how to check list of users present in all postgres database
I have around 50 of postgres database. I need to check all users with their respective database name. I know \du gives the list of all users like,
List of roles
...
- 153
3
votes
1
answer
912
views
How to migrate windows login in from one sql server to another sql server on another domain
We have a SQL server that is located in domain 1(DMN1). We are migrating databases in domain 1 to our new SQL Server in domain 2(DMN2).Corporate states that there will be no trust established between ...
- 617
3
votes
1
answer
143
views
How keep overview about database permissions?
As DB-Administrator I need to keep overview about my servers and databases in general - and from a security context about logins, users, db-roles and permissions in particular.
It is possible to ...
- 4,807
2
votes
1
answer
1k
views
SQL Server 2008: how do I hide data from a DB Maintainance User?
Our organisation employs a third party company to do maintenance on our database. To be honest, currently they act as our DBA's since we do not have one.
In order to do the maintenance work, they ...
- 21
7
votes
1
answer
12k
views
How do you list all logins for Sql Azure?
What queries can I use to list all logins for a server and database in SQL Azure?
I tried running select * from sys.sysusers but I'm guessing that's just showing the users
- 185
0
votes
2
answers
3k
views
How to display User Mapping for offline databases?
When I use the GUI (SSMS) to review the User Mapping, where the Login has mapping to a database that is offline (or otherwise not available) I get the message below and it only displays Mapping for ...
- 6,318
1
vote
1
answer
2k
views
Why doesn't Oracle show my privileges?
I have a user that is able to drop, alter, create tables and indexes. But when I list the privileges for my Oracle user it does not show any CREATE TABLE or other such privileges. How am I able to do ...
- 3,327
0
votes
1
answer
28
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 |
+...
- 101
0
votes
1
answer
33
views
What system privilege is needed for a user to manage user accounts only
I'm looking to delegate user termination to our NOC.
Requirements are:
A user NOC will be created
User NOC will execute stored procedures allowing them to either 1) lock another db account or 2) ...
- 1,865
1
vote
2
answers
217
views
Confused Logins and Users in SQL Server
In SQL Server, when setting permissions with a Grant statement, we do it on Users, not Logins. For example:
CREATE LOGIN login1 WITH PASSWORD = 'sssssssss';
use mydb;
CREATE USER user1 FOR LOGIN ...
- 375
1
vote
1
answer
3k
views
Users in SQL Server cluster
I have created a 2012 WFC and SQL Server 2014 is clustered on it. The cluster works as expected but have a question on Users:
I added a windows domain group to the cluster as sysadmin.
When the ...
- 11
2
votes
1
answer
3k
views
Can we create multiple users in one login in SQL Server 2008?
I have one database where I want 4 users in that particular database, so do I have to create 4 logins, one for each user ?
I want multiple users from one login. I tried to create a second user by ...
- 21
3
votes
1
answer
1k
views
MySQL replication and master users on slave server
Do the users initiating inserts on the master server also have to be on the slave with at least as many permissions for the replicated queries to be correctly executed? My understanding is that you ...
- 527
2
votes
2
answers
4k
views
Can I create a new user in MS SQL from windows and provide the SID
I am trying migrate databases and along with the database I am trying to also migrate the users without having to re-map the users. I was trying to recreate the windows user with the old server SID. ...
- 55
2
votes
0
answers
106
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 ...
- 143
1
vote
1
answer
672
views
Login Schema Role User Setup
Environment:
Windows Server 2012
SQL Server 2014 Standard
Public website (Site-A) on Server
Private website (Site-B) on Server
Windows App running on workstations
SQL Server 2014 Standard:
2 ...
- 202
5
votes
3
answers
4k
views
Who is the person using a SQL login?
Is it possible to find out who used a SQL-Server login?
Let's assume we suspect a person to abuse a SQL login that is supposed to be used by an application only to logon to SQL-Server. Is the domain ...
- 4,807
4
votes
1
answer
2k
views
InfluxDB - How can I limit the measures that a user can read by their tags?
I have some data that is collected by several sensors. Some users may own many of these sensors. I want to keep all the measures in a single database in InfluxDB. To differentiate the sensors I ...
- 43
0
votes
1
answer
105
views
PostgreSQL: access right problems
I have a "production" user and database on which I want to give right access on all the users belonging to a production group.
Unfortunately, I don't succeed, keeping the access denied error.
Can ...
- 213
2
votes
4
answers
23k
views
Deleted MySQL "root" user (using phpMyAdmin)...how to restore?
I'm test-running a Joomla installation (locally, using WAMP) with an MySQL database supporting it...this is in preparation to moving everything online once I have it configured.
I was working in ...
- 159
1
vote
0
answers
411
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 ...
user66276
0
votes
1
answer
3k
views
List certain user ids and drop them in Oracle
How do I list certain user ids and drop them?
For instance, I want to list user ids directly connected to database, in Oracle, and not any functional id.
I need to write a script for the automation
...
1
vote
1
answer
689
views
What is the best way to store user profiles and logins?
I need to store user profiles and logins. Is the best way to do that to have a table for logins (email, username, and password) and a separate table for their profile/info (e.g. their progress in ...
- 13
0
votes
1
answer
274
views
How do I host and separate multiple projects on one Oracle Database?
From Difference between database vs user vs schema
I'm trying to understand the concepts of the schema, user and database.
My current understanding is you cannot create a schema separately.
You can ...
- 439
0
votes
1
answer
335
views
my root account has been deleted for unknown reason, how to recover?
i have a program called heidiSQL on my computer that enables me to edit data inside my database with querys. recently tried to create a new user through this program while signed in as the root ...
- 25
4
votes
1
answer
4k
views
Do not have permission to use 'dbo' when creating a view
I want to create a user with minimal required access to two databases within a server. The user will be used by someone from a third party integrating a Business Intelligence tool into our database. ...
- 629
1
vote
1
answer
391
views
mysql user host field in slow query log
Mysql shows the following value in the slow query log
# User@Host: user[user] @ [127.0.0.1]
I'm assuming one if the "user" entries is a proxied login. An admittedly very quick glance of the code ...
- 111
3
votes
2
answers
6k
views
Postgresql: create role, schema and change ownership but not as superuser
I need to create various schema in a database and give ownership of these to specific users. I want to do this in a script, and I rather not be the postgres user or a superuser.
My user pat has ...
- 131
16
votes
2
answers
39k
views
View active MySQL connections per user
I need a query that will give me the active or open number of connections to a certain database for a certain user. I have been searching for hours and have come up with nothing so far. I am close, so ...
- 161
1
vote
1
answer
53
views
Application specific users table or mysql.users
I am using a mysql installation that handles an application with multiple users. These users have varying permissions for table access, but also need to be referenced within tables in the application ...
- 13
1
vote
2
answers
81
views
Noob questions on tables in a sql model
I'm a noob when it comes to SQL or PHP and I'm a creating a rather simple car-sharing web site. The user can engage a trip someone created and can himself create a trip. Now I'm currently designing ...
- 13
2
votes
0
answers
738
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 ...
- 21
2
votes
2
answers
77
views
How to set-up a distributed data storage system for The Real Junkfood Project
Context
The Real Junkfood Project consists of a network of pay as you feel (PAYF) cafes. We need to log the data from each of ~100 cafes, generating perhaps 50 rows each par day. I estimate that this ...
- 123
12
votes
1
answer
45k
views
How to change the login for a database's dbo user?
I just finished a successful install of SQL Server 2014 Express, onto a domain-joined VM instance of Win8.1.
During setup which I ran under DOMAIN\Admin I accepted the default configuration of adding ...
- 559
7
votes
1
answer
11k
views
Create postgres schema in db with multi user in AUTHORIZATION
Is it possible to create a schema that is owned or accessible by more than one user in the same database?
I was reading postgres create schema documentation and postgres alter schema documentation ...
- 175
1
vote
1
answer
1k
views
How to restrict access to SQL Server user in some period of time
I have two SQL Server users 'A' and 'B'.
I use user 'A' for ETL and 'B' for reporting.
My requirements is to restrict user 'B' access while user 'A' performing ETL (Extraction, Transforming and ...
- 81