Thanks, creation works fine, but how do I read existing permissions through SQL, is there some SELECT-statement I can use?
Am 14.03.2012 um 08:43 schrieb John R Pierce: > On 03/14/12 12:38 AM, Alexander Reichstadt wrote: >> this was probably asked dozens of times before, but I couldn't find where, >> and neither in the docs and what I found on the web didn't make sense. I >> found how to create users and check their permissions using terminal. But I >> need to alter and create users and permissions through libpq or SQL >> directly. I also found there to be a reference on the INFORMATION_SCHEMA, >> but still couldn't make sense out of these tables in the given context. This >> is to make a user administration inside the client frontend. What approach >> would be recommended for this purpose? > > SQL commands like... > > CREATE USER freddy WITH PASSWORD 'something'; > CREATe DATABASE freddb OWNER freddy; > > issued same as any other SQL queries, via libpq etc. > > note, the INFORMATION_SCHEMA is read only as its all implemented as VIEW's... > > > > > -- > john r pierce N 37, W 122 > santa cruz ca mid-left coast > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
