The tag has no usage guidance.

learn more… | top users | synonyms

0
votes
1answer
20 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
0answers
25 views

SQL Server group is missing after installation of SQL Server 2008 R2

I've installed SQL Server 2008 R2 and defined a local network service account to run the MSSQLSERVER service. Now I'd like to change the running user to a domain user. I know that this domain user ...
0
votes
1answer
26 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
113 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
40 views

Users in SQL Server cluster

Question on users: 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 ...
0
votes
0answers
16 views

MongoDB job on CentOS 7 has file permission errors

I have a CentOS 7 server and I've been trying to start using MongoDB. At some point, I changed group & file permissions for the following: /var/lib/mongo /var/run/mongodb /var/log/mongodb What ...
1
vote
1answer
77 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
47 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
102 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. ...
3
votes
0answers
77 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 ...
0
votes
0answers
16 views

SQL Server users when restoring from older version to newer version WITH REPLACE

Let's say we have a SQL Server 2000 database with a user named user2000. We have a database called foo on SQL Server 2000, to which user2000 has been given access. We also have a SQL Server 2008 ...
1
vote
1answer
29 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
594 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 ...
2
votes
0answers
23 views

InfluxDB - How can i limit the measures that an user can read by their tags?

I have some data that is collected by several sensors. Some users may own many of this sensors. So, i want to keep all the measures in a single database in InfluxDB. To differentiate the sensors i ...
0
votes
1answer
28 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 ...
0
votes
3answers
261 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 ...
0
votes
0answers
17 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
62 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
41 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
0answers
23 views

AWS RDS Postgresql restricted user

When you create a RDS instance (Postgresql) on AmazonWebServices you create a user that is a part of rds_superuser role. This user is sort of an administrator and is therefore not appropriate to use ...
3
votes
1answer
231 views

Best way to model a single user with multiple usernames

So I'm looking to write a website where a user will login with their email address and password, but can have multiple usernames. The context is a social gaming website. This may result in a user ...
0
votes
0answers
9 views

Designing Users table on DistributedDB

I am using SQL Server 2012 SP2 Express with PDB Wrapper 1.0.4 on 7x Partition nodes + Common server. Currently my users table is shared on common but we see high network latency. We left users table ...
0
votes
1answer
49 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
2answers
96 views

how to create 'root'@'localhost', after disappearing

for some unknown reason my 'root'@'localhost' account has disappeared from MySQL server. So in order to recreate it, I used my command line and logged in with a user called 'john91'. First, I checked ...
0
votes
1answer
45 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 ...
3
votes
1answer
242 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. ...
0
votes
1answer
46 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 ...
3
votes
2answers
343 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
30 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
52 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
145 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
43 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
vote
1answer
1k 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 ...
1
vote
1answer
35 views

least privilege MongoDB monitoring user (no access to customer data)

We use A Nagios plugin to check the status of MongoDB. Howto create a user with least privileges for this plugin? Admin acess would be a security vulnerability. I found the built in role ...
2
votes
1answer
613 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 ...
1
vote
1answer
161 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 ...
2
votes
1answer
39 views

What should be the command for following role creation requirement?

I need to create a role where the assigned user can access only the 'AdventureWorksDB" where he will have execute permission to all tables,views and stored procedures in the database. I wrote the ...
1
vote
1answer
120 views

Allow multiple users to see procedures and functions

I have GRANT ALL PRIVILEGES ON `test1`.* TO 'admin'@'%', GRANT ALL PRIVILEGES ON `test1`.* TO 'devel'@'%' (from SHOW GRANTS FOR some_user) and I have created simple procedure as admin in test1. And ...
3
votes
1answer
108 views

Allow multiple users to change functions in MySQL

I want to make multiple users and allow them to change procedures,functions and triggers in same DB. There must be user devel for developers and admin for admin, both can change developers DB, but ...
3
votes
1answer
181 views

What is the proper setup for PG user for web application

We have a web app that detects if the DB does not exist and creates it. Users like it, but my thought is that such user has too much privileges. I would optimally propose to change the DB creation ...
0
votes
0answers
23 views

Oracle: Is it safe to temporarily lock all users not belonging to SYS_GROUP?

I know you can startup an instance in restricted mode, but I need at least one other user account besides SYS and SYSTEM to have remote access to the instance, because I need to connect with that user ...
1
vote
1answer
50 views

Should database directory and file access be restricted to only the db user?

I don't know exactly how to word this question and I haven't been able to find any specifics on it so apologies if it's a duplicate. I know that it's standard practice to have database server ...
-3
votes
1answer
154 views

Implication of owned schemas for a user having db_owner privilege

Importance of "Schema owned by the user"? The user is db_owner for the db. Is it required to select owned schemas?, or else it will own all the schemas as it is a db_owner? Please provide me a detail ...
3
votes
2answers
311 views

Who is using a SQL Server database user credential?

I have a database user -- let's say "x" -- and I want to know how many Windows (desktop) users are using this database user (who2 or who is only give the current result, I want to know the entire ...
0
votes
2answers
299 views

MySQL Add/Grant user if it does not exist

I am trying to create a update/install script that adds a user and database only if it's a fresh install. The script uses a randomly generated password for the user, so using the GRANT statement as ...
1
vote
2answers
152 views

Role to view SQL server job log

We have a monitoring tool that can check if Microsoft SQL Server jobs have run successfully. What I want to do is create a user that has as little permission as possible but it must be able to watch ...
5
votes
2answers
162 views

Rebinding a SQL Server user to its login after a restore with this user

After performing a restore of a SQL Server (v12.0.2000) database, I figured that a user needs to be remapped to its login (this issue seems to be known as orphan users). And one of the simplest way to ...
0
votes
0answers
56 views

SQL Server Phantom Login

I have log shipped a database from one SQL Server 2008 R2 server to another in standby mode for reporting purposes. Permissions are granted via a Windows AD Group called DOMAIN\DB Access Group which ...
5
votes
2answers
8k views

ERROR 1054 (42S22): Unknown column 'plugin' in 'mysql.user'

I am trying to grant privileges for a user to a new database mysql> grant all on db_test.* to 'user_test'@'localhost' identified by 'usersexistingpassword'; I get the following error ERROR 1054 ...
0
votes
1answer
106 views

How many database users/admins should be created for a website?

I have created a CMS website that only had one database connection for both the admin area and the user area and it only had one user("root") with no password, and now I want to upload it, but I am ...