From: | Wim Bertels <wim(dot)bertels(at)khleuven(dot)be> |
---|---|
To: | Adam Pearson <Adam(dot)Pearson(at)4finance(dot)com> |
Cc: | "pgadmin-support(at)postgresql(dot)org" <pgadmin-support(at)postgresql(dot)org> |
Subject: | Re: pgAdmin and sudo mode |
Date: | 2015-09-01 11:15:22 |
Message-ID: | 1441106122.3083.14.camel@khleuven.be |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
Adam Pearson schreef op di 01-09-2015 om 11:01 [+0000]:
> Thanks for the response Wim, unfortunately creation of SuperUser accounts isn't something we're allowed to do (company policy) with the idea that there should only be this 1 superuser account that we sudo into for elevated permissions
>
> -----Original Message-----
> From: Wim Bertels [mailto:wim(dot)bertels(at)khleuven(dot)be]
> Sent: 01 September 2015 10:56 AM
> To: Adam Pearson
> Cc: pgadmin-support(at)postgresql(dot)org
> Subject: Re: [pgadmin-support] pgAdmin and sudo mode
>
> Hallo Adam,
>
> if you are a dba,
> probably what u are looking for is a superuser account.
>
> start pgadmin,
> in the sql window,
> type create user,
> select create user and hit the help/questionmark button
>
> sudo does not exist in sql
as said sudo in sql does not exist:
the closed you'll find is
\h set session authorization
Command: SET SESSION AUTHORIZATION
Description: set the session user identifier and the current user
identifier of the current session
Syntax:
SET [ SESSION | LOCAL ] SESSION AUTHORIZATION user_name
SET [ SESSION | LOCAL ] SESSION AUTHORIZATION DEFAULT
RESET SESSION AUTHORIZATION
\h set role
Command: SET ROLE
Description: set the current user identifier of the current session
Syntax:
SET [ SESSION | LOCAL ] ROLE role_name
SET [ SESSION | LOCAL ] ROLE NONE
RESET ROLE
they are different..,
http://www.postgresql.org/docs/current/static/sql-set-session-authorization.html
mvg,
Wim
>
> mvg,
> Wim
>
> Adam Pearson schreef op di 01-09-2015 om 08:49 [+0000]:
> > Hello all,
> >
> > Does anyone know if you can use ‘sudo’ in pgAdmin?
> >
> >
> >
> > Currently my login doesn’t have full access to the system, when I sudo
> > into the admin account I can alter / drop / create objects /
> > permissions etc.
> >
> >
> >
> > I don’t know the sudo account password and the DevOps team don’t hand
> > this out (I’m a DBA) so when using pgAdmin options are fairly limited.
> >
> >
> >
> > I can run the commands in a psql console, but it kind of seems a shame
> > to lose the auto complete and ease of use of the gui when writing
> > scripts.
> >
> >
> >
> > Googling doesn’t appear to display any results and when looking at the
> > help file none of the start options appear to list this as an option.
> >
> >
> >
> > I’m running pgAdmin 1.20 on Windows 7.
> >
> > Servers are Linux.
> >
> >
> >
> > Any suggestions to this would be appreciated.
> >
> >
> >
> > Thanks,
> >
> > Adam
> >
> >
> >
> >
> >
> >
>
> --
> mvg,
> Wim Bertels
>
> --
> Wim Bertels
> Lector
> UC Leuven-Limburg
> --
> Things past redress and now with me past care.
> -- William Shakespeare, "Richard II"
>
--
mvg,
Wim Bertels
--
Wim Bertels
Lector
UC Leuven-Limburg
--
Nothing so needs reforming as other people's habits.
-- Mark Twain, "Pudd'nhead Wilson's Calendar"
From | Date | Subject | |
---|---|---|---|
Next Message | Adam Pearson | 2015-09-02 09:04:20 | Re: pgAdmin and sudo mode |
Previous Message | Adam Pearson | 2015-09-01 11:01:07 | Re: pgAdmin and sudo mode |