Hello there are not similar statement if you would to grant rights to more database objects, you have to use script or stored procedure. regards Pavel Stehule 2009/5/27 Gauthier, Dave <dave.gauthier@xxxxxxxxx>: > What is the (is there a) grant command that I can use to create a super user > without having to specify all the DB objects? > > > > grant all on database foo to thesuper; > > and > > grant all privileges on database foo to thesuper; > > > > Don’t work. > > > > I know I can achieve what I want by submitting a grant for each and every > object in the DB. But is there a way to do it all with one command, maybe > something like... > > > > “grant all privileges on everything to thesuper” ? > > > > Thanks > > -dave -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
