Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [users]

For questions about database user accounts.

364 questions
110
votes
6 answers

Difference between database vs user vs schema

What is the difference (if any) between a database, a user, and a schema?
Ravi
  • 1,565
  • 4
  • 15
  • 20
55
votes
7 answers

How to get all roles that a user is a member of (including inherited roles)?

Let's say I have two Postgresql database groups, "authors" and "editors", and two users, "maxwell" and "ernest". create role authors; create role editors; create user maxwell; create user ernest; grant authors to editors; --editors can do what…
Neil McGuigan
  • 8,653
  • 5
  • 42
  • 57
39
votes
3 answers

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 their icons show with a red X. What does this mean?
user18718
36
votes
1 answer

PostgreSQL roles versus users, grant permissions

I'm currently learning the differences between PostgreSQL and MySQL as I've got a new project and I also intend to migrate my existing software from MySQL to PostgreSQL. I've actually started creating an HTML table with a comparison of commands (for…
John
  • 757
  • 1
  • 10
  • 23
31
votes
7 answers

Access denied for user 'root'@'%'

I used to access the root user in MySQL just fine. But recently, I am no longer able to. I am able to login fine : mysql -u root -p Here is the mysql status after login : mysql> status -------------- mysql Ver 14.14 Distrib 5.5.28, for…
jules testard
19
votes
5 answers

How to manage millions of users?

I am about to launch something really big. I need to prepare my server and database. I would like to group each set of 100,000 users in separate user tables but I do not know how to associate one user trying to log in to the appropriate user…
Chris
16
votes
4 answers

MySQL User with Host set to a Range of IP Addresses

I have a hosted MySQL DB that I need to give access to from my customers site. They have a fast broadband connection which can present them with a range of IP addresses from a fixed pool. So I need to lock down the access to their MySQL user so that…
Mark Ogier
  • 313
  • 1
  • 2
  • 5
16
votes
2 answers

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 here is what I have tried. SHOW STATUS WHERE…
Will Hughes
  • 161
  • 1
  • 1
  • 3
14
votes
3 answers

Find orphaned users

In SQL Server 2005, is there a way to find users that either don't exist at the server level (an account that was deleted at server level but wasn't disassociated from databases before it was deleted) or accounts that aren't linked (an account may…
DForck42
  • 3,068
  • 3
  • 38
  • 67
13
votes
2 answers

Feasible to have thousands of users in Postgres?

We are creating SAAS where we will at most have 50.000 customers. We are considering creating a user in the Postgres database for each customer. We will map each user that logs into our service to a user in the database in order to be very sure that…
David
  • 1,195
  • 1
  • 13
  • 27
13
votes
2 answers

Is there a simple way to add a read-only user?

I have a hosted (shared) SQL Server database and I'd like to add a read-only login. (This login will be used to build Power BI data visualization.) Looking into this, it's far more complex than I expected. Ideally, the guest user would be read-only…
Jonathan Wood
  • 347
  • 1
  • 2
  • 9
12
votes
2 answers

Adding a user to MySQL with 'name'@'%' fails with ERROR 1396

I just tried to add a new user to MySQL using CREATE USER 'name'@'%' IDENTIFIED BY '...' However, it fails with the following error: ERROR 1396 (HY000): Operation CREATE USER failed for 'name'@'%' Adding the user just for localhost works…
Petr
  • 537
  • 2
  • 5
  • 11
12
votes
2 answers

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 includes information on character encodings and…
Schmuddi
  • 223
  • 1
  • 3
  • 6
12
votes
1 answer

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 the current user as a SQL admin. Upon…
InteXX
  • 559
  • 2
  • 7
  • 17
11
votes
2 answers

How to see profile assigned to a user

Let's say i have created a user as 'TEST_USER', and then i assigned a profile to it. Now how can i see for TEST_USER which profile has been assigned? I want some query that will check what profile a user is assigned with.
VishalDevgire
  • 223
  • 1
  • 2
  • 6
1
2 3
…
24 25