Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [users]

For questions about database user accounts.

347 questions
102
votes
8 answers

Difference between database vs user vs schema

I'm really confused with the terms database, user and schema. Can anyone explain how they are different from each other (if they are)? If they are same then, what are the similarities between them? How do we use them? And how do we create them?
Ravi
  • 1,485
  • 4
  • 15
  • 20
43
votes
6 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,063
  • 3
  • 37
  • 54
35
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
  • 675
  • 1
  • 9
  • 21
33
votes
6 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
31
votes
5 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
15
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
  • 151
  • 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,018
  • 3
  • 31
  • 63
13
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
  • 183
  • 1
  • 1
  • 5
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
  • 527
  • 2
  • 5
  • 10
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
  • 3
  • 6
11
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,155
  • 1
  • 11
  • 27
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
11
votes
5 answers

Why storing users passwords at all?

I occasionally see questions asking how to safely store user passwords for a web application (using an RDBMS, I'm not talking of Facebook or Twitter). The usual answer is "salt the password, then hash it with a strong algorithm such as TDES or…
Fabian Pijcke
  • 244
  • 3
  • 9
10
votes
2 answers

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 privileges for the user account: grant select,…
mchar
  • 203
  • 1
  • 3
  • 8
1
2 3
…
23 24