Questions tagged [users]

For questions about database user accounts.

Filter by
Sorted by
Tagged with
1
vote
1answer
270 views

Object Level Security

I have a database that will be shared across multiple related types of applications for different users. I want to be able to restrict each database user to essentially have full control over their ...
4
votes
2answers
4k views

SQL Server Service Accounts

We have a new Windows 2016 server and I have to install SQL Server 2016 standard edition. Once I install and configure the SQL server I will move my existing production database to the new db server. ...
1
vote
1answer
2k views

How to structure a MongoDB database to allow for multiple users to use the same account with restrictions based on roles?

Ok, firstly I'm very new to MongoDB, and newish to DB development/management as a whole. I've done a unit using Oracle through uni, but apart from just manipulating fields through the phpmyadmin ...
0
votes
1answer
92 views

Track MySQL Procedure Changes in MySQL

We want to keep track of changes being done to MySQL procedures only, actually recently our procedures seem to have overwritten to some previous versions and we were unable to track it that who did ...
0
votes
1answer
162 views

How to create a database user for oracle 11g on windows 8?

I am new to oracle database and therefore is trying to follow the office guide. (link to the guide) However, it seems that the guide is for Windows 7, so in step 2 - creating database user, it says: ...
1
vote
2answers
3k views

mysql.user table damaged suddenly

I didn't do an upgrade or anything but suddenly MySQL (MariaDB) stopped working after a restart. This is the log: 2018-02-11 14:10:02 140193631740480 [Note] Using unique option prefix '...
2
votes
2answers
4k views

EXECUTE AS USER = 'dbo' - The user does not have permission to perform this action

I created a trigger that now works fine as result, but there is 1 line where I run a query: DECLARE @source as nvarchar(30) = (SELECT client_net_address FROM sys.dm_exec_connections WHERE session_id =...
0
votes
1answer
133 views

How to create mysql user with CREATE USER grant but without access to new databases?

I need mysql admin_user (not root user) which can create write_user with permissions: CREATE, UPDATE, INSERT, DELETE and SELECT. admin_user and write_user have access to main_db. write_user will ...
6
votes
1answer
851 views

Disable multiple logins in one step

Is there a way to disable multiple sql logins based on a set of users in a table? For example: ALTER LOGIN (Select userid from tbl_user) DISABLE;
0
votes
1answer
334 views

Authorization dbo maps to a user with an old machine name

I am trying to run a command that looks like this: Create ASSEMBLY [AssemblyName] AUTHORIZATION [dbo] From ... When this runs, it returns an error message: Could not obtain information about Windows ...
3
votes
1answer
3k views

postgres create limited user that can select tables and columns of those tables

I have an app that automates the making of a PostgreSQL database, and also automates the creation of a database user. This database user is given limited access for security purposes, as it will be ...
3
votes
1answer
5k views

pg_hba.conf allow mutliple I.P. addresses for single user

In my pg_hba.conf, I need a single user to be allowed to connect from two completely different IP addresses (like work and home, for example). Something like the following would be really nice: host ...
-1
votes
1answer
62 views

Authorized, all privileged DB user and a DB instance with the same name - does it have a name? [closed]

Is there a term that encompasses an authorized, all-privileged DB user and a DB instance with the same name? Should I call this a DB stack / DB unit / DB packet / something else? Does this "stack" ...
2
votes
2answers
1k views

MongoDB Cluster - Can't access member of shard with credentials

I have a Sharded Cluster and I am trying to access a specific member of a replica set within a shard. When connecting to the mongos it is fine, but when using the same credentials on a member of the ...
-1
votes
1answer
53 views

Getting User Access in Individual Databases MSSQL

So, here is the scenario. I need to give user access on multiple databases ( but not all on the instance), and in this case, i cannot use AD group which is already having certain grants on all ...
3
votes
2answers
11k views

Cross-database view - Not able to access database under the current security context

We have two databases, Adb and Bdb. In Bdb, we create a view that references another view in Adb, like so: CREATE VIEW Bdb.dbo.Bview AS SELECT * FROM Adb.dbo.Aview. We have an SQL Authenticated ...
0
votes
0answers
112 views

Grant user permission to create new schema but not view existing schema

Is there a way to allow the user to create new schemas (and acquire privileges to schemas he created), but not view existing schemas (or a way to blacklist a list of schemas that the user is not able ...
4
votes
1answer
3k views

What is the significance of the principal_id in sys.schemas?

What is the meaning of the principal_id in sys.schemas and when would it ever be different from schema_id? 1> SELECT LEFT(name,20), schema_id, principal_id FROM sys.schemas; 2> GO ...
1
vote
2answers
4k views

Expiration date on a user in a specific database

Some of our developers needs access to some of the databases in production for a short period. Is there a way for me to set an expiration date on a user in a specific database? Just to clarify I do ...
3
votes
1answer
2k views

Minimum credentials on SQL Server to connect via Power BI Desktop

Note: This is not a Power BI issue, this is a DB credential issue. In Power BI Desktop, I am trying to connect to a database, but I only want that user to have SELECT access. I have one User that is ...
0
votes
3answers
501 views

Disabling password change for a MySQL user

Is it possible for MySQL users to prevent/disable changing their password with just the USAGE option? There are no global permissions allowed. I tried to google, but had no luck.
2
votes
2answers
202 views

One user for all database applications

We are in a process of upgrading our SQL Server database. We are also ditching the Oracle databases that we had and are migrating all the databases to SQL Server 2016. The internal db structure is ...
0
votes
2answers
47 views

Restore user in DataBase that in master have mapped the child database but in child database doesn't have the user created

I don't know why te following database arrive to this point but this is the situation In master security you can see the defcon\axadmin user with DAXTest database mapped But if you go to the ...
1
vote
1answer
257 views

user security inheritance in SQL Server 2016

I'd like to build a bunch of new databases (several dozen) in SQL Server 2016. However, I'd like all users to access a single database (called SECURITY for now), and apply security to that one ...
0
votes
1answer
81 views

How to allow creation and deletion of a database or collections with user and password

I created a user with the role of userAdminAnyDatabase db.createUser({user: "Username", pwd: "password", roles: [{role: "userAdminAnyDatabase", db: "admin"}]}) and also user with the role of ...
0
votes
1answer
46 views

Application slows down during Back up

The Application is 24/7 up Full back up time is 4 am and back up size is 92 gb. It takes one hour to complete the back up. During those time users complain that the application freezes. Just wanted ...
0
votes
1answer
1k views

Firebird2.5-superclassic on Ubuntu 16.04 LTS

I installed firebird2.5-superclassic using sudo apt-get install firebird2.5-superclassic and then ran sudo dpkg-reconfigure firebird2.5-superclassic and set the password per https://firebirdsql.org/...
0
votes
1answer
204 views

inserting actual username of a person who edited record into a table with trigger MySQL

I have a problem with inserting current user who actually insert,update or delete the data into the table. I know that the subject was described many times and I did a lot of research, yet ended up ...
0
votes
1answer
39 views

MySQL - Unable to login with password, but without password its working

I have a master-slave setup, Slave is not in read only mode.(we can do all writes). I have created a user. create user 'bhuvi'@'%' identified by 'bhuvi'; grant all privileges on *.* to 'bhuvi'@'...
6
votes
2answers
26k 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
64 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
956 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
98 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
2k 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
471 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
2k 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
26 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
10k 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
490 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
949 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/...
0
votes
1answer
307 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
151 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
362 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 ...
0
votes
1answer
56 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
122 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 2
3
4 5
7