Questions tagged [permissions]
Privileges granted to an account or role through the security mechanism of an operating system, database manager or other system.
1,631 questions
0
votes
1
answer
58
views
How to I apply default privileges in Postgresql when changing ownership?
The problem (short version)
I have to import data from files to PostgreSQL, and this has to be done on the server side. Files are uploaded to the PostgreSQL server and then imported to the database by ...
- 395
0
votes
1
answer
79
views
What is used to manage privileges for RDBMS databases?
For context I primarily work with PostgreSQL and Snowflake but my understanding is that privileges in RDBMS servers are far more alike than different, so most will apply to this question and I'm ...
- 3
1
vote
1
answer
46
views
RDS master user shouldn't be able to query msdb
I don't like working in RDS. I can't even query sysjobschedules with my Master user
This data isn't completely gated off from me. For example I can see the schedule data in the job management UI.
I ...
- 5,841
0
votes
0
answers
42
views
Administrator part of Administrators group cannot execute initdb
A built-in Administrator account (part of Administrators group) is executing a batch file file.bat inside User1 environment using runas /user:Administrator "cmd /k file.bat" command. The ...
Nur
0
votes
1
answer
91
views
Win Server 2016 - PostgreSQL 15 and 16 Install Errors - Failed to Load SQL Modules into Database Clusters
Note that PG10 was installed on this server. Prior to installing the new version, I stopped and disabled the PG10 service.
Here's the OS version of the server in question:
I used the EDB installers ...
- 145
0
votes
1
answer
39
views
Is it possible to run Django migrations on a Cloud SQL replica without being the owner of the table?
I'm using Google Cloud SQL for PostgreSQL as an external primary replica, with data being replicated continuously from a self-managed PostgreSQL source using Database Migration Service (DMS) in CDC ...
- 117
0
votes
0
answers
66
views
Why can a SELECT query produce a "permission denied for schema X" error when permission IS granted for that schema?
I have spent a couple hours digging into documentation, online blogs, and the particular permission settings for this DB. My best lead is https://stackoverflow.com/a/28503453/5419599 (more on that ...
- 599
0
votes
0
answers
77
views
SQL Server schema owned by a non-existent user
I'm seeing some odd behaviour in SQL Server with schema owners. I have two schemas which I want to be owned by the same user (so that I can create a cross-schema indexed view).
According to sp_tables, ...
- 113
4
votes
1
answer
151
views
Selecting single role for Postgresql user
Is it possible in Postgresql (v15.7) for a user with multiple roles to specify which role(s) should apply when logging in? For instance, if I were granted the roles l3_support_engineer and ...
- 213
0
votes
0
answers
60
views
SQL Backup folder permission issue
Having an issue on one of our SQL servers at work in which the SQL backup folder permissions are not right and the folder is inaccessible. I just noticed this problem when attempting to setup nightly ...
0
votes
0
answers
64
views
Postgres 16 pg_basebackup not working due to system identifier mismatch
I am using the Alpine docker image for Postgres 16 for this experiment.
I have one container which is running and has some tables.
I create a second container which is also running but has no tables.
...
- 1
2
votes
2
answers
421
views
Permissions needed to start/stop SQL Agent in SSMS
I'm working on a new SQL Server instance, but the SSMS options to start/stop/restart the SQL Agent are grayed out.
I am connected from another PC. My user is in a group that has sysadmin permissions ...
- 384
0
votes
1
answer
100
views
Restricted user access only on main replica?
We have an Availability Group (AOG) on SQL Server 2019 with two replicas (primary and secondary). The database within the AOG is set to restricted user access mode on the primary node (read-write). ...
- 465
0
votes
2
answers
90
views
AD Group Permissions in SQL Server behaving differently between 2 servers [duplicate]
I have 2 SQL Servers running SQL Server 2019. They each have a sql login that uses windows authentication (an AD Group) "SG-GroupA" and the group has 5 windows users in it.
Each of the ...
- 390
0
votes
2
answers
59
views
Postgres permissions for nonexistent objects
Does dropping and recreating a postgres database (or schema or table) cause a loss of any granular permissions that were formerly associated with that resource?
For comparison, is it like a Posix ...
- 101