Questions tagged [users]

For questions about database user accounts.

Filter by
Sorted by
Tagged with
7
votes
2answers
31k views

cannot execute as the database principal because the principal does not exist - DB Restoration

I have received one database backup from one of my client and now I'm trying to restore it into my system. I tried to search this issue on google and tried most of the suggested solutions but none of ...
2
votes
1answer
67 views

SQL application connection using one Windows user

We are currently looking to update an old application security structure and would like to go for an approach where the application connects to SQL via one Windows login with the required Read/Write ...
0
votes
1answer
1k views

created a user with clusterMonitor and dbOwner role, but db.getRoles() shows enableSharding role

I created a user with full privileges in it's own database (dbOwner) and read-only access to administrative commands (clusterMonitor) use customerdb (mongod-3.4.7) customerdb> db....
1
vote
0answers
114 views

are there possible draw backs when setting 'dbo' to users who have default schema as null?

as part of a bigger operation I have been putting together this script below that basically generates a create user script for each user of the current database. When the user has a default_schema it ...
5
votes
1answer
3k views

Postgres 10. Hide users/roles from other users

I have a postgresql 10 installed and I want to hide the name of users/roles to other users. I searched through other posts and somebody suggested this: REVOKE SELECT ON pg_catalog.pg_authid FROM ...
0
votes
1answer
38 views

A trigger that show the user that has made an insertion

I have the following code create table o_c( op_id NUMBER(10,0) PRIMARY KEY NOT NULL, n_c VARCHAR2(50) NOT NULL, op VARCHAR2(500) NOT NULL, amount NUMBER(9,2) ); create table a_o( a_id NUMBER(10,0) ...
2
votes
1answer
542 views

User created automatically because of AD Group?

I have a Development SQL Server that I'm managing with Active Directory Groups, sometimes when I do my checks on the server I find that some users were "automatically" added to SQL Server Database ...
7
votes
1answer
2k views

Is there any way to prevent a PostgreSQL user to change his/her own password?

I'm administering a PotsgreSQL server and recently I realized that my "nonsuperuser" users have the possibility to change the secure passwords that I assign them for insecure ones. I searched in the ...
1
vote
2answers
3k views

What are possible ways of handling multiple users accessing the same database via custom web API? [closed]

I am very new to databases and Web design, but I understand enough to know that designing a good database is crucial, so I would like to prepare for that conceptually. However, I was unable to find ...
0
votes
2answers
27 views

Very strange GRANT permission issue

I am having a very strange issue here with a web app that I have seen working fine in the past. The server is a simple LAMP stack running MySQL 5.6.30. SQLSTATE[HY000] [1045] Access denied for user '...
8
votes
2answers
12k views

How do I translate a Windows SID to an SQL Server server_user_sid?

There is this nice SQL Server function SUSER_SNAME which translates a server_user_sid to a user name. This is useful for translating well-known Windows SIDs to (potentially localized) user names. ...
-1
votes
2answers
975 views

SQL Authenticated users can't access database

I have just created a user account with SQL authentication with username: test1 and password of password. When I log into this account via the server explorer in Visual studio it is fine. Until I ...
10
votes
5answers
5k views

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 ...
2
votes
0answers
981 views

How do you grant SQL Server 2016 user-permissions to access local files?

I'm trying to develop a SSDT sln, where a .csv is parsed. However I get the error: Operating system error code 5(Access is denied.) According to this post: https://stackoverflow.com/questions/...
1
vote
1answer
526 views

If a user is created in a primary postgres database, will the user be copied to a follower?

Say a user is created in postgres 9.6 with some specific privilege set: CREATE USER foo_user WITH ENCRYPTED PASSWORD 'foo_password'; GRANT CONNECT ON DATABASE bar_db TO foo_user; GRANT USAGE ON ...
0
votes
1answer
162 views

ORA-01017 error when conecting to Oracle Database Standard Edition 2.12.2.0.1.0 for Microsoft Windows x64 (64-bit)

I've installed and created non-CDB database (single tenant) database. Created a user account using the SYS user, granted it the CONNECT and CREATE SESSION roles. When I attempt to login using the ...
3
votes
1answer
2k views

Limit number of simultaneous queries by user

I am looking for way to allow one user to execute maximum 3 queries at the time. Is there such possibility in Postgres? Due to some technial difficulties I cant limit number of connections, and the ...
0
votes
2answers
5k views

Oracle Schema Privileges Other Users

I have a user with only CONNECT privileges and I'd like to know if RESOURCE would be enough to query objects in other schemas and create objects in my own schema based on that. i.e.: create a view in ...
1
vote
1answer
394 views

Why do roles and schemas have (mostly) the same name?

When I create a database and add a user I get an interface with options. On that interface I can choose: Owned Schemas Membership This question on dba.stackexchange HERE says schemas and roles are ...
1
vote
1answer
97 views

How to rename MySQL users without logging into MySQL?

I wanted to rename the default Linux username on a Lubuntu 16.04 VM (from osgeo live) from user to newuser. I followed answers in this question to rename the Linux user. But after renaming, I cannot ...
-1
votes
1answer
124 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
14k 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
12k 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
536 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
191 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
3k 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
10k 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
130 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
14k 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
1answer
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
171 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
17k 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 ...
6
votes
3answers
6k 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
820 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
71 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
684 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
112 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
875 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 ...
6
votes
1answer
8k 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
186 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
733 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 2 3
4
5
7