Skip to main content
Share Your Experience: Take the 2024 Developer Survey

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
9 votes
9 answers
58k views

Error Authenticating Proxy Account when Executing SSIS job

I have a SQL Server instance that runs 5 scheduled tasks each night, each of which run SSIS packages. These packages have been running for years and the associated steps run via a Proxy Account (...
0 votes
1 answer
543 views

Explicitly revoke privileges from a user who is a member of a role that is granted those privileges in PostgreSQL

Let's say I have a user on my PostgreSQL instance called "myuser", and I add it to a new group called "update_all" like this: CREATE ROLE update_all WITH NOLOGIN ROLE myuser; I ...
0 votes
1 answer
360 views

Does SSRS report user needs database level permission?

I have a separate reporting server and a separate database server. Now on the Reporting server site settings I could see there are some roles and users. Suppose a User BOB has ‘POWER USER’ role ...
4 votes
1 answer
191 views

Granting SELECT...INTO permissions

I've created a new schema, archive, and am able to create, read, update and delete tables within it. I have an EXTERNAL_USER who I'm trying to give permissions to so that they can carry out select.....
0 votes
1 answer
393 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
1 answer
300 views

Query for: view users and permissions (roles) from root security folder (MS SQL)

On the Internet I found a lot of scripts how to display users and their permissions under a particular database (Security folder under table) - for example sp_helpuser. Currently, however, I need to ...
0 votes
3 answers
1k views

Create Sequence Permission for Postgres

When my postgres function is tries to create a new sequence, it returns a permission denied error. It looks like the only way to make it work is to give Create permission on schema using the below ...
0 votes
1 answer
45 views

SQL Job Roles: How to grant a group permission to access SQL Jobs with unique mapping?

Issue Developers on the same team are members of a Windows_Group. These developers create jobs which they each own. Only the owner can edit the job so they cannot work together on same job. Because of ...
0 votes
1 answer
280 views

Execute Permission Denied on Stored Procedure using Microsoft JDBC Driver and Windows Authentication

I have a Microsoft SQL Server database that I use Stored Procedures to read/write data to through a Integration Engine in this case InterSystem IRIS. Originally I was using a local server user to do ...
0 votes
1 answer
1k views

Mysql grant limited by IPv6 subnet

I want to permit access to a mysql server over IPv6 and limit access to the particular account to our ULA subnet we are using (fdd7:03d7:6247::/48). The manual seems to suggest that wildcards are ...
1 vote
1 answer
5k views

How to check who has permission to execute a stored procedure?

I have two environments/servers. Each has two databases, say DATABASE_A and DATABASE_B. There is a stored procedure in DATABASE_A (in both environments) that queries DATABASE_B and also calls multiple ...
0 votes
1 answer
1k views

Grant permissions only if an object exists, but without mentioning the object twice

We have a number of database build scripts that grant permissions to specific objects (sprocs, functions, etc) only to specific roles. We have recently moved to an automated deployment model that has ...
0 votes
1 answer
3k 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: ...
14 votes
1 answer
17k views

What are the privileges required to execute a trigger function in PostgreSQL?

What are the privileges required to execute a trigger function in PostgreSQL 8.4? It seems that privileges set to a role do not matter when executing a trigger function. I think I have seen some day ...
0 votes
1 answer
294 views

MySQL Proxy on Current User

I'm trying to grant permissions to the current user logged in depending on their role, but it doesn't seem possible to have a select statement at the end of the GRANT PROXY # TO # command The code I ...
0 votes
1 answer
352 views

Disabled SA user is listed as logged in

I was looking for the last time users have been logged into the system and saw SA as being used. Strange is that SA is disabled by default and not used on our systems. How is that possible, what am I ...
0 votes
1 answer
44 views

Import roles from <16 into >=16

I've got a backup from PostgreSQL 15 that I'm trying to get imported into PostgreSQL 16. One of the breaking changes between the versions is to "Restrict the privileges of CREATEROLE and its ...
0 votes
1 answer
26 views

How to get list of permissions for a role in Postgres?

I'm trying to do what is described here. That is, execute the following: BEGIN; DROP ROLE role_name; ROLLBACK; and get the: list of permissions it can find that are granted to the role. I can't ...
0 votes
1 answer
1k views

How to list all functions with arguments that a role is allowed to execute in Postgres?

I found how to list tables a role has permissions on. I found how to list all functions with arguments. My question is: How to list all functions with arguments a role is allowed to execute?
0 votes
1 answer
354 views

Can Postgres restrict usage of the SET and SHOW commands?

Is it possible to restrict a role from being able to set arbitrary session variables, or from being able to view them? select current_setting('x'); show x; Even after I've switched roles to a one ...
28 votes
5 answers
99k views

Giving file system access to the SQLSERVERAGENT virtual account

I'm trying to grant the NT Service\SQLSERVERAGENT Windows account file system access, based on the marked answer in this question. I believe it's a virtual service account, and it does not show up in ...
1 vote
1 answer
1k views

Granting specific permissions on ALL tables

I have a tutorial that users need to type in PostgreSQL commands. I don't give the script to users simply because it's a learning experience. Everything in the script below is typed in except for the ...
3 votes
1 answer
576 views

How to set minimal permissions to change SQL Azure Firewall rules

I have a desktop app that connects to SQL Azure database. Some users have dynamic IP addresses, and it is not possible to get them to use fixed addresses. I've written an ASP.NET page hosted on the ...
0 votes
3 answers
1k views

Cascading REVOKE not working in MYSQL

I've read about an SQL option of cascading permissions when issuing a REVOKE statement. I've googled for how this option is implemented in MySQL, but haven't found it at all. This is the docs page ...
0 votes
0 answers
13 views

Why does removing `skip-grant-tables` cause resource conflict error for mysqld?

After hours of searching, I have managed to narrow a mysqld issue down to a point, which I cannot find reason for. I am attempting to launch multiple instances of mysqld on my Ubuntu server. When ...
0 votes
1 answer
337 views

SQL Server permissions to create arbitrary custom-types and stored procedures with them

What are the most restrictive permissions to allow for creation of arbitrary custom types and stored procedures with use the types in SQL Server? For instance: create type dbo.MyType as table (dt: ...
0 votes
1 answer
679 views

The SELECT permission was denied on the object '__EFMigrationsHistory', database 'master', schema 'dbo'

I'm trying to create asp.net core web api. (https://youtu.be/EmV_IBYIlyo?si=GcPVN7BuautDy6-j&t=1351) At the point where he executes Add-Migration InitialCreate and Update-database my console ...
0 votes
1 answer
2k views

Grant VIEW DATABASE STATE on master DB

I am asked to provide access to VIEW DATABASE STATE in the master DB of an Azure SQL Server instance (Premium P6) to an external user (vendor) in order some investigation to be done. When run "...
0 votes
1 answer
5k views

Postgresql: Permission denied to schema to user created based on master with rights

I'm trying to write a function that eventually will rotate users. Currently I have the code below which works and creates a new user using the prior user which ultimately has the same rights as the ...
1 vote
2 answers
49 views

My user does not exist or dosent have any permision to alter or update tables

I have this query alter table NashvilleHousing add FixedSaleDate Date; update NashvilleHousing set FixedSaleDate = CONVERT(Date, SaleDate) got this error: Msg 4902, Level 16, State 1, Line 11 ...
0 votes
1 answer
14 views

granting privileges to user in postgresql

I'm trying to setup a new project with a Postgresql 15.5 database. I have a running instance. If I create a new database psql --command "create database \"tagger-db\"" create a ...
1 vote
3 answers
2k views

Can't create database even with all privileges

[mariaDB on RedHat 7.7] I just want to create a new database, but found "access denied": create database lamp_k; ERROR 1044 (42000): Access denied for user 'lamp'@'localhost' to database 'lamp_k' ...
1 vote
1 answer
18 views

Logical replication security risk with run_as_owner = false

The docs say If the subscription has been configured with run_as_owner = true, then no user switching will occur. Instead, all operations will be performed with the permissions of the subscription ...
0 votes
0 answers
20 views

Grant permission for a user to create objects in a PostgreSQL schema is not working

I have recently upgraded to PostgreSQL 15 and observed that a db user say X (not a owner of schema) is no longer able to create a table in public schema. From the below release notes looks like it is ...
9 votes
8 answers
24k views

Permission to view execution report in SSIS Catalog

We are currently using SSIS 2012. Is there any way for a user to view execution reports under SSIS Catalog without being ssis_admin or sysadmin? This is for production environment and we don't want ...
0 votes
1 answer
817 views

How to do point in time recovery of binary log files into .sql file

I have written a shell script to do an incremental backup of MySQL database. For point in time recovery I'm using the binary logs generated in /var/lib/mysql directory. For point-in-time recovery, Im ...
1 vote
1 answer
428 views

postgresql: why owner of table is unable to select from it?

In postgresql documentation on GRANT option it is written: There is no need to grant privileges to the owner of an object (usually the user that created it), as the owner has all privileges by ...
0 votes
2 answers
3k views

Grant All on All tabes in schema?

I have a question about grants... I ran the following command, assuming it would allow me to make any changes to the tables in the public schema: grant all on all tables in schema public to User1; ...
1 vote
1 answer
1k views

MariaDB Read-Only user can't see database, why?

I have 2 users, one with ALL grants, another with SELECT only. User 1 can see the database, not user 2, why? Read-only user: MariaDB [(none)]> SHOW GRANTS FOR 'readonly'@'%'; +----------------------...
4 votes
1 answer
9k views

Verify if user has read access to a table

I'm developing an ETL, which must read data from a table. There are times that my user's access to that table is revoked. So, to avoid the ETL failing, before reading the table I must verify if I have ...
2 votes
1 answer
204 views

Permissions to be granted to developers to investigate jobs, queries, and packages

I have just installed a new sql server 2014 server, migrated some databases there and connected some applications to them. These servers have also SSAS and SSIS. I have a group of developers there ...
0 votes
4 answers
1k views

Is there a privilege in Oracle that lets a user view the objects in another schema?

Is there a privilege in Oracle that lets a user view or not view the list of objects in another schema? I've got a user where I've given them select rights to a view in another user's schema. However, ...
2 votes
1 answer
1k views

MySQL privileges for roles aren't applying to users?

I've done what I consider to be sufficient research with no answers to justify posting this question here. I am attempting to grant users permission to execute certain stored procedures. And because ...
1 vote
1 answer
2k views

Postgres SQL on AWS RDS how to grant permission for schema, select on tables to user

I have logged in as superuser and created a readonly user. When I run grant command, it says that schema does not exists I am logging in as root: sql -h myhost_name -U root -d postgres -W grant ...
27 votes
4 answers
64k views

Find objects linked to a PostgreSQL role

Some times ago I created a PostgreSQL user named user1 (PostgreSQL 9.4.9). I want to drop this user. So I first revoke all permissions on tables, sequences, functions, default privileges and ...
9 votes
4 answers
35k 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 ...
2 votes
1 answer
1k views

Database model with Users, Resources, Permissions

I am fairly new to the DB design. I need to handle what a user can do on a specific resource. One of the main queries I need to drive is: Get all the cars a user has write permission to. I think ...
3 votes
1 answer
2k views

mongodb keyfile permission denied

I configured in /etc/mongod.conf to enforce keyfile access control, in security option enabled, keyFile is /root/dbtest.key (the absolute path of keyfile). I already gave the ownership to mongodb user ...
3 votes
1 answer
2k views

How can I list all privileges that a PostgreSQL role has?

... including the inherited ones? When organizing access rights through different roles, this seems to be something really useful, yet I haven't found anything that would show how to do this. AIUI, I ...
2 votes
1 answer
856 views

MySQL - Grant user permission to create table as long is it has a prefix in the name

I'd like to grant a user permission to create tables in a database so long as the table has a particular prefix, let's say example_. I've tried the following: $ mysql -u root -p mysql> CREATE ...

1
2 3 4 5
32