I have problem with permission, I need to use a user no SUPERUSER.
I use commands:
CREATE ROLE $USER LOGIN;
ALTER user $USER noCREATEDB NOCREATEROLE noCREATEUSER NOINHERIT;
ALTER USER $USER with password 'XX';
REVOKE create on SCHEMA public from public;
revoke all on schema PUBLIC FROM $USER;
I try with "revoke all on schema PUBLIC FROM PUBLIC;", but after give GRANT
SELECT user can't use SELECT. When I use "revoke CREATE on schema PUBLIC
FROM PUBLIC;" and give GRANT SELECT user can use SELECT.
On 7/27/07, Alvaro Herrera <[EMAIL PROTECTED]> wrote:
&g
When I use revoke that you send, I revoke permission in all database. Is
there possible I use this revoke in one BD only?
On 7/27/07, Alvaro Herrera <[EMAIL PROTECTED]> wrote:
>
> Anderson Alves de Albuquerque wrote:
> > I need to use a user that can not have permission to c
I need to use a user that can not have permission to create table in one
BD.
I use revoke, I tray with "revoke all on database XXX to|from USERNAME;",
but I don't have success.
Could someone help me?
With revoke I only limit access in tables.