Questions tagged [permissions]

Privileges granted to an account or role through the security mechanism of an operating system, database manager or other system.

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

MySQL: Block ANALYZE TABLE Queries

Is there a way to revoke access for ANALYZE TABLE which is granted by needed Insert privilege? I have an application that throw multiple ANALYZE TABLE queries per second. And am looking for a way to ...
2
votes
1answer
40 views

How to grant access to a specific table across all databases in Mysql?

I want to Grant access like so: > GRANT INSERT, UPDATE ON `%`.my_table TO 'user'@'%'; ERROR 1146 (42S02): Table '%.my_table' doesn't exist This is not possible per Mysql documentation on grant: ...
1
vote
1answer
29 views

Copy mysql_native_password to new server

I did a mysqldump of my entire database mysqldump --defaults-file="/home/ubuntu/.my.conf" -u api --all-databases > full-dump.sql . I setup a new mysql and phpmyadmin and loaded the ...
1
vote
2answers
34 views

How to list all grants per user/role on PostgreSQL

I've run these statements on Postgres CLI (I'm using PostgreSQL v13.1): CREATE ROLE blog_user; GRANT blog_user TO current_user; And I created a function CREATE FUNCTION SIGNUP(username TEXT, email ...
0
votes
1answer
25 views

User Permisssions White List vs Black List

I have Applications, Roles, Users, Permissions, Application_Permissions, User_Permissions, Role_Permissions, Application_Roles and Role_Permissions tables. So, permission can be defined at application ...
2
votes
1answer
106 views

Allow user to GRANT certain permissions to others

I have tried googling this but may well be using the wrong terms... permissions and the like aren't my strong point. What I want to do is first create a role - eg 'Snr_Analyst' - with certain ...
3
votes
3answers
152 views

Error 297, Severity 19 trying to create new table as sysadmin

I am completely scratching my head right now. I have two database instances that I am trying to add a table to, and both give me the same error: The user does not have permission to perform this ...
0
votes
0answers
29 views

Linked server anonymous login error

I am trying to access a database in my UAT server through a windows login credential. When I try to access the database, I get the error Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON' This ...
0
votes
1answer
12 views

How to structure MySQL database tables for users and how to handle adding/removing permissions?

I am making a database structure for users, who can become part of a group, and within that group the admin of the group can assign as many permissions to a user as they would like. This part seems ...
1
vote
0answers
28 views

Why is my Postgres database working for a while and then not able to “start server” once restarted?

Recently, I've started playing around with an old Raspberry Pi 3 b+, and I thought it would be good practice to host a Postgres database on my local network and use it for whatever I want to work ...
2
votes
2answers
41 views

How to allow a certain domain user to create databases on a remote SQL instance?

I want to allow for a certain domain user to be able to create databases on a remote SQL instance. What steps are necessary and is it possible to perform those steps programmatically in a C# ...
0
votes
1answer
17 views

Allow user to drop only tables / views created by that user in MySQL

Is it possible to allow a user to only drop tables and views that he/she created in MySQL? How is this achieved?
0
votes
0answers
19 views

MySQL User Privileges by IP using Wildcards (%)

To make a long story short, I'm taking over some support for an electronic medical record (EMR) with a MySQL backend. When troubleshooting an issue with functionality, we discovered the EMR ...
1
vote
2answers
40 views

Select failed from V$LOGMNR_CONTENTS when called from a procedure

Assuming the following user with these privileges granted: -- create admin user on CDB CREATE USER c##myadmin IDENTIFIED BY myadmin DEFAULT TABLESPACE system QUOTA UNLIMITED ON system ACCOUNT UNLOCK / ...
1
vote
1answer
48 views

Permission denied for view beyond its own schema

There are two schemes rohdaten_fiat and staging_fiat. I have created a view in the latter one based on the first one. CREATE VIEW staging_fiat.udz_odx_dtcs AS SELECT * FROM rohdaten_fiat....
0
votes
1answer
33 views

Deny DDL_ADMIN permissions to a role on [dbo] schema

I have several database schemas like, [ext],[stag],etc and of course the built in [dbo] schema, and also have a role called [MyRole]. My plan is to add [MyRole] to the DDL_ADMIN role, so they can ...
0
votes
0answers
17 views

Why isn't “DROP OWNED BY” freeing up my ability to drop a role?

I'm using Postgres 9.6 on Mac. I would like to drop a user/role. I logged in as my super user (postgres) and tried this postgres=# DROP ROLE chicommons; ERROR: role "chicommons" cannot be ...
0
votes
1answer
31 views

How to GRANT the USAGE privilege on SCHEMAS that will be created in the future

I need a role to access a schema owned by another role, which can be dropped and re-created in the future. For the first part of my requirement, i.e. for an existing schema, the following would do: ...
0
votes
1answer
26 views

Why does ALTER AUTHORIZATION on a table drop all permissions on the target?

This fact is documented here: ALTER AUTHORIZATION (Transact-SQL) If the target entity is not a database and the entity is being transferred to a new owner, all permissions on the target will be ...
3
votes
1answer
83 views

PostgreSQL: Administration as Non-Superuser

I have a database on a shared PostgreSQL server. I possess the ownership of the database and the CREATEROLE privilege and would probably be able to get a few other privileges if I request them but I ...
0
votes
0answers
24 views

Can't see backup files in the shared folder

Yesterday we tried to perform a restore operation but faced with an issue where SQL Service Account couldn't see backup files that were located in shared folder. The SQL Service Account that we use is ...
0
votes
1answer
18 views

How do I terminate the old connection when a user of the same account login again?

I want to set up a server while multiple users could login at the same time, as long as they are not the "same user". How could I set it up so when the user with the account username "...
0
votes
1answer
49 views

Confused by GRANT ALL PRIVILEGES causing Access Denied for database 'mysql'

I thought I understood grants in mysql, but this particular problem has me stumped. I am logged in as the 'dbadmin' user on a mysql 5.6.27 database. +---------------------------------------------------...
0
votes
1answer
211 views

ORA 01031 Insufficient privileges on GRANT SELECT on ALL_CATALOG to a user as system user

Command: GRANT SELECT ON ALL_CATALOG TO appdbuser * Error: ERROR at line 1: ORA-01031: insufficient privileges PROBLEM: I want my Oracle XE system user (<-important) to be able ...
2
votes
3answers
153 views

Oracle allows inserting into table even after revoking quota

I am studying creating users and granting roles and I have come across this scenario where I grant unlimited quota to a user, insert into the table and then revoke the quota. I expected that after ...
0
votes
1answer
52 views

Switching SQL Server service credentials to AD account

To pursue best practice for SQL Service accounts, I’m working through changing the SQL service account to be AD accounts for our existing SQL servers. The first one I did was fine because it was a ...
0
votes
2answers
36 views

reapply permissions post sql server restart

In our environment, users were granted read/write/ddladmin permissions on tempdb database (dev/qa/prod). These permissions will be lost when SQL Services restart, as tempdb rebuilds every time. One ...
0
votes
0answers
12 views

How do I enable pgadmin4 (PostgreSQL12) to read and write files in directories of other Linux Users on RHEL8/CentOS8 [duplicate]

While trying to export a query result set from PGAdmin4 on PostgreSQL12 to a CSV I am encountering the following error: ERROR: could not open file "/home/linuxusername/Downloads/data.csv" ...
0
votes
3answers
77 views

Revoke and Grant Privileges on SQL Server Database

I have a user that I want to grant all privileges on all database tables except for DROP, TRUNCATE, DELETE, INSERT and UPDATE. The Database has over 300 tables and I can't do this one by one. I need ...
7
votes
4answers
2k views

What could cause SQL Server to deny execution of a SP at first, but allow it later with no privileges change?

A user (Windows login) just complained he was denied the execution of a procedure. I went to check and verified he had the privileges to execute it. I didn't change anything (and right now I'm the ...
0
votes
2answers
95 views

Changing Table Ownership in Postgres from Postgres User

I have a database with some tables that was created by a certain user. All tables and sequences in that DB were owned by that user. I needed to change the owner of those tables and sequences to be ...
1
vote
0answers
27 views

Create a user with rights and privileges between root and limited (CRUD single database) user

Is it possible to create a mid-root MySQL user, who will have the ability to create other users, with scope limited to databases which mid-root user creates? This mid-root user would not have the ...
0
votes
2answers
116 views

MySQL do not accepts wildcard for tables name level grant

Trying to grant a user select privilege on multiple tables using wildcards as following: GRANT SELECT ON 'DBname'.'foo_%' TO 'username'@'%' IDENTIFIED BY 'password'; But keep giving the following ...
0
votes
1answer
25 views

Stored Procedure Signed by Certificate Unable to Add Members to Database Roles

I created a Stored Procedure that performs the Following tasks: Creates database Change owner to sa Set recovery model Creates users in database Adds users to database roles. Grants execute and view ...
0
votes
1answer
62 views

MariaDB: How can I grant read-only privileges for Stored Procedures?

I've granted SELECT privileges for a user to select on all tables of a database. However that user is unsable to view store procedures. I'd want to grant only the permission for SHOW CREATE PROCEDURE (...
0
votes
1answer
24 views

GRANT ROLE TO USER in MySQL

I created one role QI_RO, granted all privileges on all schemas on the server and I was trying to grant role privilege to another user but throwing error. GRANT QI_RO to test_user@'%'; Error Message: ...
1
vote
1answer
32 views

I need a way to give a sql authenticated user read access to a windows directory

A SQL-authenticated user SBA_USER is selecting from a View which uses Linked Server which points to an Excel spreadsheet in the I:\Folder directory on a windows server. Problem I have is that the ...
0
votes
1answer
179 views

How is the “Adjust memory quotas for a process” user right assignment used in SQL Server 2019?

I am looking at the Configure Windows Service Accounts and Permissions doc (https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/configure-windows-service-accounts-and-permissions?...
0
votes
0answers
4 views

SSAS permissions needed for Xevents

What permissions are minimum needed to allow developers to create and view Xevents sessions on an SSAS instance. Do they need Full control on the instance or can this be done with less permissions? ...
1
vote
1answer
48 views

how to run SQL query without permission

there is a sql query that joins both example1.dbo.table1 and example2.dbo.table2 User1 has no select permission on example1 DB. User1 has select permission on example2 DB. User2 can run that query how ...
0
votes
2answers
42 views

User cannot query cross-database, despite having permissions for both databases

SQL Server 2017 Enterprise (14.0.3356.20), running on Windows Server 2016. I have a situation where an application's user needs to join on a table in a separate database in the same instance, but I'm ...
-2
votes
2answers
53 views

How to prevent database shrinking

We have a 3° party application, with an application user who needs to be db_owner on the database (not my choice) on SQL Server system. All stored procedures are encrypted in this database. At some ...
0
votes
1answer
39 views

drop postgresql schema public without losing extensions

As part of my development workflow, I often use drop schema public cascade; create schema public; in order to get a clean state of the test database before re-loading my table and stored procedure ...
0
votes
1answer
19 views

Grant permissions to only specific tables in a Schema

I am having a schema where I wanted to grant permissions in the following manner. What is the right way of doing this? To keep this simple, I am putting an example. SCHEMA - HR TABLES: GEO_EMPLOYEE ...
0
votes
0answers
9 views

In Redshift how can I create an user which which has only user creation privileges?

The primary requirement is to automatically create or alter users based on user information stored in a table. I am planning to write a stored procedure / use Databricks notebook to do the automation. ...
0
votes
0answers
22 views

Mysql user with grant option cannot grant access to another user

in my mysql server there is a user mgenkin with the following privileges: +---------------------------------------------------------------------------+ | Grants for mgenkin@% ...
0
votes
0answers
10 views

db_datawriter and db_ddladmin on a server-level? [duplicate]

Ok, since SQL Server 2016 we have new server-level permissions that allow to grant connect and select to/on any exising or future databases on the server instance use master grant connect any ...
0
votes
0answers
13 views

SQL Group Execution Rights to Read only SPs and functions - By not changing objects' schemas

We have a SQL Developer Group.. We want to give them access to execute functions and sps but not to any that amends data in any way.. We currently only have the DBO schema and all objects sits on that ...
0
votes
1answer
164 views

Oracle: ORA-00942: “table or view does not exist” in SQL Developer

in SQL Developer when i get session information he return me this error message: (ORA-00942: "table or view does not exist"). Can i resolve this with add grant to privilege of my user? Wich ...
0
votes
1answer
19 views

Is it possible to grant a user the equivalence of ownership over a another users schema?

Im trying to create a trainer/trainee environment in Oracle 18c XE. So far I have 4 trainee users which all have the hr-sample installed. Now, I plan on having one trainer user that is able see ...

1
2 3 4 5
28