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
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Favorites infavorites:mine
infavorites:1234
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 Search options user 6219

Privileges granted to an account or role through the security mechanism of an operating system, database manager or other system.

1
vote
I think you cannot do this using only the tools PostgreSQL offers. On one hand, there are no default privileges, as you noticed. The REVOKE command issued on a template DB (template1 in most cases) …
answered Apr 13 '17 by dezso
4
votes
The problem here is the ALTER DEFAULT PRIVILEGES statement you issued will apply only to tables that are created by user_name: You can change default privileges only for objects that will be creat …
answered Sep 25 '17 by dezso
4
votes
What you see typically happens when the non-privileged user doesn't have schema level privileges. In this case, they cannot list the objects inside the given schema - with the command you tried. See …
answered Apr 11 '17 by dezso
3
votes
You can achieve this goal by revoking certain privileges. You might have the reasons to do so - the only scenario where I'd start thinking about it is multi-tenancy. Still, in this case, it is bette …
answered Oct 14 '16 by dezso
1
vote
Looking up the documentation, two things to mention: not sure whether a space is allowed before @ (not declared explicitly, but the user string takes the user_name@host_name form - and since this is …
answered Oct 14 '12 by dezso
2
votes
You will have to edit your pg_hba.conf file. If you really want to reduce possible access to a single user (see the note below), you will need the following lines, and only these: # TYPE DATABASE …
answered Jan 28 by dezso
3
votes
If you need to do this only once, the quickest way is probably the following. Find all the schemas you want to touch by querying, for example, the pg_namespace system catalog: SELECT nspname FROM p …
answered Nov 19 '15 by dezso
3
votes
the new role (in your example, rails) has the LOGIN option, myuser won't inherit it. The reason is that GRANT only gives permissions, while LOGIN is an attribute of the user/role: CREATE USER rails …
answered Oct 25 '16 by dezso
7
votes
There is no builtin role like that in PostgreSQL. However, you can set up one: CREATE ROLE db_datawriter; After this, you have to assign write privileges (usually INSERT, UPDATE, DELETE, maybe TRU …
answered Jun 15 '18 by dezso
7
votes
As the owner of the table, you can create a function (or, if you are on Postgres 11 or newer, a procedure) which disables the trigger of your choice like: CREATE OR REPLACE FUNCTION disable_this_trig …
answered Feb 20 by dezso
5
votes
According to the documentation, what one needs for creating tables in a schema is CREATE on that schema. This you think you revoked, but as you experience it didn't really happen - the only plausible …
answered Sep 23 '15 by dezso
1
vote
I try to answer your question - to be correct, I try to answer the question I think you've asked (see the comments). Until then I'll assume that a virtual table is simply a table and you want to coun …
answered Nov 7 '12 by dezso
4
votes
The documentation of GRANT says the following: CREATE For databases, allows new schemas to be created within the database. For schemas, allows new objects to be created within the schema. To ren …
answered Apr 18 '13 by dezso
4
votes
The way to prevent table modification is to change the ownership to a different role. Tables can be altered only by the owner and superusers - so change the ownership to a non-superuser. I find it p …
answered Feb 2 '18 by dezso
4
votes
The CONNECT privilege for PUBLIC looks somewhat special: \l template1 | postgres | UTF8 | Hungarian, Hungary | Hungarian, Hungary | postgres=CTc/postgres That is, user test (which is the memb …
answered May 30 '13 by dezso

15 30 50 per page