The tag has no usage guidance.

learn more… | top users | synonyms

1
vote
2answers
39 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
32 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 ...
1
vote
2answers
30 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 ...
0
votes
1answer
87 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
17 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 ...
0
votes
1answer
29 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 ...
2
votes
1answer
36 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
35 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
46 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 ...
0
votes
1answer
36 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
12 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
33 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
23 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
216 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
47 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
40 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 ...
4
votes
2answers
80 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
32 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 ...
3
votes
2answers
2k 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
50 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 ...
0
votes
0answers
67 views

Cannot access MS Access DB with non-Admin users

I have created several users in a MS Access database using "User-Level Security Wizard" in Access 2013. The problem: I am only able to log in with users belonging to Admins group. Other users ...
0
votes
1answer
34 views

MySQL default user

I have mysql.user table with this content: select host, user, password from user; | localhost | root | *75267AEB7355CEEE80EAB92D19FF50095AD9BB3E | | linux | root | ...
1
vote
1answer
347 views

How to set user-level security in 2007+ MS Access?

I've read this MS info which should cover my problem. There are quite clear steps: Open the .mdb or .mde file that you want to help protect. On the Database Tools tab, in the Administer ...
0
votes
1answer
45 views

Best way to remap database login to new database user and keep previous database user

Here's what my environment looks like: Active Directory (mydomain.local) - Groups - group01 - Members - aduser01 SQL Instance - Logins - mydomain\group01 - ...
1
vote
1answer
30 views

MySQL Drop User Fails for Remote Host

We're clearing out some old MySQL users that connected from remote hosts during a database transfer. Why is this DROP USER query failing for the user asdfasdf_imac4? I'm logged in as root. mysql> ...
1
vote
1answer
66 views

MySQL: 'user'@'hostname' vs 'user'@'IPaddress'

I needed an user to be able to log in on our MySQL server 5.6 from machine foobarhost, IP 10.11.12.13. Therefore I created a user 'joe'@'foobarhost' but he was unable to log in. I had to create an ...
0
votes
0answers
74 views

ASP.NET Session Database - what user to create?

I am migrating a .Net 3.5 website with SQL Server 2005 Enterprise databases to SQL Server 2012 Enterprise (website still .Net 3.5). It uses ASP.NET session state database of type "t" Temporary. ...
-1
votes
1answer
28 views

Users' physical characteristics - design

I have to build a database for an employment agency. For each user will be stored physical characteristics like height, weight, hair color...(9 fields in total). I thought I could just build a ...
1
vote
1answer
78 views

Export all MySQL users

I need export all of a MySQL database users (including permissions) for a migration. There is over 5,000 users, what is the best way to do this? Should I just dump the mysql.user table?
1
vote
1answer
62 views

How to distinguish between system and user defined roles in a single database?

Is there a way to distinguish between a system role/user and a user defined role/user? As system role/user I understand a role/user which is installed/assigned implicitly at the time the database has ...
0
votes
1answer
88 views

impdp syntax for schema that is not available on other database

My intention is to import the data of schema 'SCOTT'. I have exported it from db1 using expdp scott/tiger schemas=scott dumpfile=scottexp.dmp ...... Now When I try to import the same in database db2 ...
0
votes
0answers
16 views

MySQL Data User Ownership

Which OS User will own MySQL Datafiles? For example: If i run the next command: create database test; It creates a folder on the datadir. Is there a variable that controls the ownership and ...
0
votes
1answer
327 views

Allow access to enter data through forms, but not full database access

Using Access 2013 or Sharepoint 2013 is it possible to give someone access to data entry forms that work with a back end database whether Access database or Sharepoint SQL. But from everything I've ...
1
vote
1answer
55 views

Create/copy new superuser from an existing one

I have a superuser for a PostgreSQL database, let's call him userX. How can I make a new superuser (let's call him userY) with all the same permissions, access, etc...? Basically, I want a clone of ...
0
votes
0answers
18 views

Auto created accounts mysql

i have a small question about accounts auto-created after a fresh mysql install. there is an account with Host = localhost, user = 'No user name specified', password = 'No password specified' if i ...
0
votes
2answers
171 views

How to prevent users other than DBAs from creating database links

To begin, please keep in mind that I am a very green DBA. I have done prior research and have not really found anything too promising, or maybe it just seems that way because I am still struggling in ...
1
vote
1answer
56 views

Preventing orphaned users in SQL Server 2008 R2

I've recently had a situation where a database was refreshed from production to staging, and the users on the database ended up orphaned. These are sql server users, not mapped to windows ...
0
votes
2answers
43 views

Creating database level user in MYSQL

Our MySql production server has two different databases in it. For reports I want the user to only be able to see reports database and not main database. I created A user 'username@%' for the reports ...
0
votes
1answer
60 views

How to set up an SQL Server authentication login for a database instead of using Windows Authentication

Not sure what I am doing wrong so I have included the parameters I used which I used the existing login and this article for reference: ...
6
votes
2answers
261 views

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 ...
4
votes
1answer
117 views

Schemas and user permissions

When our custom, home-grown CMS creates data tables using the GUI, it creates them against the site-specific user schema (i.e. sitename) instead of the dbo schema. The issue is that our ...
0
votes
0answers
67 views

Restored database is missing user

I have a SharePoint content database that has been restored into our test environment. I am getting errors in the SQL log indicating our SharePoint service account is not able to access the database. ...
0
votes
1answer
73 views

Default user group in phpMyAdmin

I am setting up a multi user environment for shared hosting. Since phpMyAdmin 4.1.0 it's possible to create user groups, add users to them and define which functions they may use. Now this is a great ...
0
votes
1answer
21 views

Restricting the # of Rows a User can return in a single query

A concern has come up recently about employees who have read access to our internal databases being able to download large amounts of data for nefarious purposes. My question is whether it is ...
0
votes
1answer
61 views

Comma List vs Multiple Records

I am currently building out an application that will contain many users, two roles and two groups. Logically we want users to be able to be administrators of other users within the two groups. User ...
2
votes
1answer
185 views

Has some command that lists the privileges of a user in db2?

I'm using db2 9.7 on linux and i want to list my privileges on database... Ex: SYSADM, SECADM, DBADM, etc. So, has some command in db2 that lists the privileges of a user in db2?
0
votes
1answer
103 views

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 ...
1
vote
1answer
19 views

Can I minimize maintenance of duplicated Windows + SQL Auth logins?

In our environment, SQL authentication is the norm, but Windows auth is possible when users are using RDP. As a result, each physical user has two logical logins for each instance and two logical ...
1
vote
1answer
44 views

Simplest way to log in as Oracle user different from schema user and still see all tables,… of schema?

What is the simplest way to log in as user X and see all tables,... of schema Y as if they belonged to X? With an Oracle 11g database, I would like to log into the database using user X but all the ...
0
votes
0answers
76 views

Not able to drop a user from Redshift

I'm encountering a very annoying problem when attempting to delete a user from our Redshift DB. I've already did the following: 1. changed the ownership on all the tables related to that user. 2. ...