Questions tagged [users]

For questions about database user accounts.

Filter by
Sorted by
Tagged with
-1
votes
1answer
122 views

New to SQL: trouble with being refused access to local Adventureworks installed server

Evening, I recently installed Visual Studio 2015, SSDT, SSMS, SQLExpress2014 and LocalDB. I'm attempting to do this tutorial: https://technet.microsoft.com/en-us/library/c1e68a88-0f82-415d-becc-...
1
vote
2answers
12k views

Default user Accounts in Mysql

I'm new to MySQL and installed MySQL in Ubuntu 16.04. At the time of installation I have given password for root. In the terminal I can access only root user and created user only. bharath@bharath-...
1
vote
1answer
10k views

Root max connections per hour exceed

I made a mistake and set the max_connections column for root to '1', so now every time I try to connect to change it I get: ERROR 1226 (42000): User 'root' has exceeded the '...
0
votes
1answer
484 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 ...
0
votes
1answer
162 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.
1
vote
2answers
2k 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?
4
votes
4answers
9k 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 ...
0
votes
1answer
129 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 ...
3
votes
2answers
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 ...
5
votes
2answers
12k 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 ...
3
votes
0answers
2k 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 ...
0
votes
2answers
144 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 ...
8
votes
1answer
15k 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 ...
5
votes
3answers
5k 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 ...
2
votes
1answer
770 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 ...
1
vote
0answers
69 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 ...
4
votes
3answers
3k 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 ...
5
votes
1answer
18k 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 ...
3
votes
1answer
591 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 ...
3
votes
1answer
106 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 ...
2
votes
1answer
809 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 ...
4
votes
1answer
7k 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
0
votes
2answers
2k 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 ...
1
vote
1answer
1k 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 ...
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
1answer
32 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
vote
2answers
183 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 ...
1
vote
1answer
2k 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 ...
2
votes
1answer
2k 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 ...
3
votes
1answer
641 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 ...
1
vote
2answers
2k 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. ...
2
votes
0answers
102 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 ...
1
vote
1answer
608 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 ...
5
votes
3answers
3k 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
votes
1answer
1k 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 ...
0
votes
1answer
87 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 ...
2
votes
4answers
18k 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 ...
1
vote
0answers
224 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 ...
0
votes
1answer
1k 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
1answer
323 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 ...
0
votes
1answer
153 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 ...
0
votes
1answer
256 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 ...
4
votes
1answer
2k 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. ...
1
vote
1answer
238 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 ...
2
votes
2answers
4k 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 ...
10
votes
2answers
26k 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 ...
1
vote
1answer
44 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 ...
1
vote
2answers
57 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 ...
2
votes
0answers
561 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
2answers
64 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 ...

1 2 3
4
5
7