Search Results
| Search type | Search syntax |
|---|---|
| Tags | [tag] |
| Exact | "words here" |
| Author |
user:1234 user:me (yours) |
| Score |
score:3 (3+) score:0 (none) |
| Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
| Views | views:250 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| Status |
closed:yes duplicate:no migrated:no wiki:no |
| Types |
is:question is:answer |
| Exclude |
-[tag] -apples |
| For more details on advanced search visit our help page | |
Results tagged with permissions
Search options not deleted
user 141659
Privileges granted to an account or role through the security mechanism of an operating system, database manager or other system.
4
votes
1
answer
1k
views
PostgreSQL: why altering default privileges in specific schema to revoke all privileges on t...
The question can pretty much translate into: why the following PostgreSQL command does nothing?
ALTER DEFAULT PRIVILEGES
FOR ROLE ownerrole
IN SCHEMA myschema
REVOKE ALL PRIVILEGES ON TYP …
- 293
1
vote
Accepted
PostgreSQL: why altering default privileges in specific schema to revoke all privileges on t...
Because it is the way PostgreSQL works.
This was not clear at the time the question was posted but this was answered in the BUG #16124: Altering default privileges problem pgsql-bugs thread:
Alterin …
- 293