* Florian G. Pflug ([EMAIL PROTECTED]) wrote:
> I'd like to be able to connect to postgres, and automatically assume a
> specific role.
Couldn't you just have 'SET ROLE ' in the user's .psqlrc? At
least, if that's how they're connecting I think that'd work...
Enjoy,
Ste
* Florian G. Pflug ([EMAIL PROTECTED]) wrote:
> I can do that with "alter user set role " too...
> But I'd like my users to be able to connect as either role "dev" or
> role "admin", depending on the task they want to do.
Alright, can you describe *exactly* what you'd want to see then? Is
this a
"Florian G. Pflug" <[EMAIL PROTECTED]> writes:
> I'd like to be able to connect to postgres, and automatically assume a
> specific role.
Why don't you just connect as that role to begin with? This seems like
a pretty low-value frammish.
regards, tom lane
---
I'd like to be able to connect to postgres, and automatically assume a specific
role.
I imagine something like
create role myuser ;
create role dev noinherit ;
create role admin noinherit superuser ;
grant dev to myuser ;
grant admin to myuser ;
Now, I'd like a connect as "myuser/admin" to be e
