grant all privileges on database

grant all privileges on database test to auser

As far as I can tell this does nothing. Intuitively this command suggests
that the auser would be able to access and modify the database test in
anyway. It would also suggest that as new tables for the database auser
would automatically have access to them.

Instead it appears that we have to still individually grant access to
tables on an individual basis. It seems to me that if it did pass these
blanket privileges on it would be very useful and make administration a
lot easier. While it is not hard to initially grant the individual access
(i am looking for a script) it is a pain in the butt to maintain. Is this
in fact how it works?

While I am sure someone will reply that by forcing us to individually
grant access on a table by table basis you are inherently forcing the
administrators to maintain high security - which is a good thing. However
i would then reply that in fact because most db admins are lazy this means
that they won't even bother and just use the super user privilege instead.