| CARVIEW |
Select Language
HTTP/2 200
date: Thu, 31 Jul 2025 04:13:42 GMT
content-type: text/html; charset=utf-8
cf-ray: 967a43bfbe5ec1c2-BLR
cf-cache-status: DYNAMIC
cache-control: private
set-cookie: prov=ebfb1557-a36f-4012-b50b-a9e3c353060a; expires=Fri, 31 Jul 2026 04:13:41 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-clacks-overhead: GNU Terry Pratchett
x-frame-options: SAMEORIGIN
x-request-guid: 417aaa02-aeaf-44f7-90f9-511badce04f1
x-worker-origin-response-time: 487000000
x-dns-prefetch-control: off
set-cookie: prov=ebfb1557-a36f-4012-b50b-a9e3c353060a; Path=/; HttpOnly; Domain=stackexchange.com
set-cookie: __cf_bm=4eHMIbOo818F0FUenhZHwIpKbQENeIKWBfrlwAUSybA-1753935222-1.0.1.1-TrGvwXBYzHmsXn3CWhpJp03pcJf.1VvqedgfpHf6537HuWs87cYe69bDK.oGWKguhqEnLnndE8jH9fISjfmOqJB.zoexCqpoev32XeU_4rQ; path=/; expires=Thu, 31-Jul-25 04:43:42 GMT; domain=.stackexchange.com; HttpOnly; Secure; SameSite=None
set-cookie: _cfuvid=Xt_8zj0SiuPWn1wbqP0OiAEw8F5Nlv77l0JNKFH8Fr4-1753935222233-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
The 2025 Developer Survey results are in. Explore insights into technology and tools, careers, community and more.
View results.
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,625 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
0
votes
1
answer
11
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 ...
0
votes
0
answers
36
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
67
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
131
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
50
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
53
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
368
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
81
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
67
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
41
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
50
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
132
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
121
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
73
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
86
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:...
- The Overflow Blog
-
-
- Featured on Meta
-
-
Related Tags
sql-server × 701
postgresql × 298
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
database-design × 24
backup × 24
trigger × 24
more related tags
Hot Network Questions
- Is it commonplace/acceptable for university professors to not teach Evolutionary Biology based on their religious beliefs?
- I have made a darligton pair circuit to amplify +/- 10mA to +/- 10 A . But it showing only postive swing. i need negative swing too. what should i do
- How should I talk about definitional uncertainty in seemingly well-defined measurands, arising at high resolutions?
- FOR XML PATH and OPTION() can't be together in query?
- Where does "kinda" ("kind of") come from?
- The dative plural form "den Einen" in Schopenhauer's 19th-century German – can "ein-" be used for plurals?
- Can a body part of a defeated monster act as an associated object for the Teleport spell to find a creature's lair?
- Area of a Quadrilateral Formed by Intersecting Lines in a Triangle
- "One can" in technical writing--good, bad, indifferent?
- Seven-dimensional cross product
- Identify Last-Layer Perm of a Rubik's Cube
- How many possible MD5 hashes are there, 16³²? Or do MD5 checksums have error correction (in which case <16³² possible hashes)?
- Reason why golems do not run on wheels
- If Satan is not omnipresent, how can he tempt or test multiple people at the same time in different places?
- Shakespearean grammar: "hath" and "has" in the same sentence
- Are all Universities this internally cut-throat?
- Is Samson referred to/mentioned in the siddur/liturgy?
- Why not use the "age" tool for encrypted backups?
- Bell always pinging on slight jolts
- Integral with multiple variables
- Efficient generation of pseudorandom permutation over a small domain
- Command to give a dimension expression with an optional argument
- What is known about the third time derivative of the expansion of the Universe?
- Was the Silk Road really a conduit of ideas?