| CARVIEW |
Select Language
HTTP/2 200
date: Wed, 23 Jul 2025 14:28:03 GMT
content-type: text/html; charset=utf-8
cf-ray: 963bdcabfaf58a2a-BLR
cf-cache-status: DYNAMIC
cache-control: private
set-cookie: prov=910a4a0c-9f88-4e8d-a164-6e657139c746; expires=Thu, 23 Jul 2026 14:28:02 GMT; domain=.stackexchange.com; path=/; secure; httponly
strict-transport-security: max-age=31536000; includeSubDomains
vary: Accept-Encoding
content-security-policy: upgrade-insecure-requests; frame-ancestors 'self' https://stackexchange.com
x-frame-options: SAMEORIGIN
x-request-guid: af93ba31-7caa-4f8a-b53d-8b44dc2c189b
x-worker-origin-response-time: 510000000
x-dns-prefetch-control: off
set-cookie: prov=910a4a0c-9f88-4e8d-a164-6e657139c746; Path=/; HttpOnly; Domain=stackexchange.com
set-cookie: __cf_bm=3AXaA7590yNyC3x5cVR8SPTzlUEOhUQdJRfzNNJADjE-1753280883-1.0.1.1-r8dJ88OLZ6BAUJWfs1JbqutN7jeUEcNfOvKjSvtYYUXujMXoeyTke8ivMfBmmYJN5AYy6jZS0U.cZT0bwavzOfCZePvCfj2ckYV_P0.aDKc; path=/; expires=Wed, 23-Jul-25 14:58:03 GMT; domain=.stackexchange.com; HttpOnly; Secure; SameSite=None
set-cookie: _cfuvid=jWt2gZ1_Xad9svVWvVZ0CpcyVY_R9m0ArlyJa2vTcp8-1753280883082-0.0.1.1-604800000; path=/; domain=.stackexchange.com; HttpOnly; Secure; SameSite=None
server: cloudflare
content-encoding: gzip
Newest 'permissions' Questions - Database Administrators Stack Exchange
Skip to main content
Stack Exchange Network
Stack Exchange network consists of 183 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
Visit Stack Exchange
Teams
Q&A for work
Connect and share knowledge within a single location that is structured and easy to search.
Learn more about TeamsQuestions tagged [permissions]
Privileges granted to an account or role through the security mechanism of an operating system, database manager or other system.
1,624 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
0
votes
0
answers
31
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 ...
0
votes
0
answers
66
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, ...
4
votes
1
answer
129
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 ...
0
votes
0
answers
48
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
49
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.
...
2
votes
2
answers
367
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 ...
0
votes
1
answer
75
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). ...
0
votes
2
answers
64
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 ...
0
votes
2
answers
40
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 ...
0
votes
0
answers
49
views
Db2 - Enable specific admin function(s) for generic, non-admin users
In Db2 (v11.5, 12, LUW) - what is the best way to grant/enable specific administrative functions with required permissions for applications?
E.g. a client/server application wants to make dynamic ...
0
votes
1
answer
126
views
Restricting view for specific databases
We have a SQL Server instance (2016 Standard Edition). I am creating a user with db_datareader permission for a single user database.
Is there any way to restrict the user from viewing other databases ...
0
votes
1
answer
120
views
xp_regread() returned error 5, 'Access is denied.'
I can understand when permissions to folders are missing,or restore,or bulk insert, but even me being an admin on the box is not helping on the error below.
what permission is missing?
this is what I ...
0
votes
0
answers
70
views
PSQL: postgres could not open file for writing: permission denied
On my Linux machine, the SQL COPY TO command fails trying to copy to the file fdo.txt. The file access control list for this file is as follows:
# file: home/kaj/fd/fdo.txt
# owner: postgres
# group: ...
0
votes
1
answer
82
views
Why can't I create a new stored procedure?
I need to copy existing stored procedures from one SQL-Server database to another one.
In the first SQL-Server database (the source), when clicking on "Stored Procedures", this is what I see:...
0
votes
0
answers
69
views
Best practice for modern (pg16+) role/schema management
I'm more of a data engineer than administrator and my role/schema management knowledge is more or less frozen in time since 8.4. I'm aware that pg15 tightened public schema restrictions, and pg14 ...
- The Overflow Blog
-
-
- Featured on Meta
-
-
Related Tags
sql-server × 701
postgresql × 297
mysql × 231
security × 168
role × 138
oracle × 135
sql-server-2012 × 112
sql-server-2008-r2 × 104
users × 89
sql-server-2014 × 74
stored-procedures × 65
schema × 63
sql-server-2008 × 59
sql-server-2016 × 57
logins × 55
view × 37
sql-server-agent × 36
mariadb × 30
ssms × 30
t-sql × 30
access-control × 27
amazon-rds × 26
backup × 24
database-design × 24
trigger × 24
more related tags
Hot Network Questions
- Is a Rakshasa Immune to True Strike?
- Repository with SQLite in Python
- Why Schrodinger wave equation is totally different from classical wave equation?
- Are some of (most of?) what we describe as "mistakes of our senses/perception", mistakes of our reasoning process?
- Must hospitals care for unidentifiable individuals indefinitely?
- Is there a smooth function approximating the min of a constant and a variable
- Entity Framework - Is there a safety mechanism to prevent accidentally running Update-Database?
- Where did the baby AT motherboard format come from?
- Did Webster's Dictionary define Fascism by its relationship to corporations until 1987?
- Calculating the wall thickness in a hollow rotating cylinder space habitat
- When you view a historical event with an incorrect modern lens
- How would a DiVicenzo machine prepare the maximally mixed state with a small number of ancilla qubits?
- "Tumas t'hom" from merely walking on a non-jewish grave?
- How much time should I take for "self transfer" without checked-in baggage?
- How should a typical reward curve look like while training a RL model
- Meaning of「えっ、えぇ……」here (spoiler warning for kanokari fans)
- OId Movie about an alien city that plays a repeating melody
- Why were two 2x6 boards installed on top of a window rough sill?
- How to model This Twisted Torus?
- Dystopian 80s sci-fi movie about the USA choosing mediocrity
- Prevent equation label from shifting down
- Business technical issues lead to unsuccessful payment being considered successful. Do I have any duty to notify?
- How can I automatically replace curly braces { and } in LaTeX macro arguments—e.g., in math formulas—for label generation?
- Will I lose my seat reservation on Deutsche Bahn EC if I skip the first leg?